Page 1 of 1

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

Posted: Thu 19 Jul 2018 14:08
by Welton3
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."

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

Posted: Thu 19 Jul 2018 17:18
by alexa
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 ?

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

Posted: Thu 19 Jul 2018 20:02
by Welton3
Done and done.

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

Posted: Fri 20 Jul 2018 11:13
by alexa
We will investigate this issue and will answer you as soon as possible.

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

Posted: Fri 14 Dec 2018 07:55
by .jp
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.