Getting an error in dbForge when editing/viewing a SQL file

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
Welton3
Posts: 23
Joined: Thu 04 Sep 2014 15:36

Getting an error in dbForge when editing/viewing a SQL file

Post by Welton3 » Thu 19 Jul 2018 14:08

I am using version 1.0.410, and I am getting an error when editing several SQL scripts. The error message says "dbForge Studio Express for PostgreSQL has encountered an unexpected error." The error dialog pops up repeatedly. I have included some SQL below that is currently causing the problem:

Code: Select all

create or replace view vw_temp_mt_view_meta_data as
with inner_view_meta as
(
  select c.relname view_name,
         d.description meta_info
    from pg_class c
         left join pg_namespace n on n.oid = c.relnamespace
         left join pg_tablespace t on t.oid = c.reltablespace
         left join pg_description d on d.objoid = c.oid 
                                    and d.objsubid = 0
   where pg_get_userbyid(c.relowner) = current_schema
     and c.relkind = 'v'
     and d.description > ''
), view_meta as
(
  select view_name, 
         regexp_split_to_table(meta_info, chr(10)) meta_info
    from inner_view_meta
)
select view_name,
       array_to_string(regexp_match(meta_info, 'primary_key is (\w+)'), '') primary_key_column,
       array_to_string(regexp_match(meta_info, 'foreign_key on (\w+)'), '') foreign_key_column,
       array_to_string(regexp_match(meta_info, 'foreign_key on \w+: (.*)'), '') foreign_key_info
  from view_meta;
Also, if I try to submit the error, I get a secondary error that says "Can not send report."

alexa

Re: Getting an error in dbForge when editing/viewing a SQL file

Post by alexa » Thu 19 Jul 2018 17:18

Could you please click the 'click here' highlighted in blue link, copy the full text of the error and e-mail to supportATdevartDOTcom and alexaATdevartDOTcom ?

Welton3
Posts: 23
Joined: Thu 04 Sep 2014 15:36

Re: Getting an error in dbForge when editing/viewing a SQL file

Post by Welton3 » Thu 19 Jul 2018 20:02

Done and done.

alexa

Re: Getting an error in dbForge when editing/viewing a SQL file

Post by alexa » Fri 20 Jul 2018 11:13

We will investigate this issue and will answer you as soon as possible.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Getting an error in dbForge when editing/viewing a SQL file

Post by .jp » Fri 14 Dec 2018 07:55

Hello,

Just let you know that a new version of the product was released.
Please update your tool to the latest version (2.0) and check whether the problem exists.

Best Regards.

Post Reply