SqlDbx
You are not logged in.
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
This is a bug.
It will be fixed in a next release.
Thank you for reporting it.
Offline