Getting an error in dbForge when editing/viewing a SQL file
Posted: 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:
Also, if I try to submit the error, I get a secondary error that says "Can not send report."
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;