SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-07-21 10:06:42

Alx
Member

Objects are not loaded when connecting to database.

Hi guys, I am trying SqlDbx 4.17 personal,

When opening one of the Postgres databases table list is completely empty and the same is for functions, views etc. As per our DB admin there is an error preventing the client to receive the object list. He sees the below error in DB log:

ERROR: |22003|integer out of range

SELECT c.relname AS table_name, nc.nspname AS table_schema
, (CASE WHEN (nc.oid = pg_my_temp_schema ()) THEN 'LOCAL TEMPORARY'
         WHEN (c.relkind = 'r') THEN 'BASE TABLE'
         WHEN (c.relkind = 'v') THEN 'VIEW'
         ELSE NULL END)::varchar AS table_type
, '0'::VARCHAR issystem, c.reltuples::integer trows
, NULL specific_name, c.oid, c.relhasoids::integer
FROM pg_namespace nc JOIN pg_class c ON nc.oid = c.relnamespace
WHERE c.relkind IN ('r', 'v') AND nc.nspname='xxxxx'
UNION
SELECT routine_name, routine_schema, routine_type, '0', NULL, specific_name, NULL, NULL 
FROM information_schema.routines WHERE routine_schema='xxxxx'
UNION
SELECT trigger_name, trigger_schema, 'TRIGGER', '0', NULL, NULL, NULL, NULL
FROM information_schema.triggers WHERE trigger_schema='xxxxx'
UNION
SELECT sequence_name, sequence_schema, 'QSEQUENCE', '0', NULL, NULL, NULL, NULL
FROM information_schema.sequences where sequence_schema='xxxxx’

Is it a bug or expected?

Offline

#2 2016-07-21 14:57:36

sqldbxhelp
Administrator

Re: Objects are not loaded when connecting to database.

This is a bug.
It will be fixed in a next release.
Thank you for reporting it.

Offline

Board footer

Powered by FluxBB