SqlDbx
You are not logged in.
Pages: 1
With version 12 the Objects List is empty.
I've got this error in log:
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='public'
UNION
SELECT routine_name, routine_schema, routine_type, '0', NULL, specific_name, NULL, NULL
FROM information_schema.routines WHERE routine_schema='public'
UNION
SELECT trigger_name, trigger_schema, 'TRIGGER', '0', NULL, NULL, NULL, NULL
FROM information_schema.triggers WHERE trigger_schema='public'
UNION
SELECT sequence_name, sequence_schema, 'QSEQUENCE', '0', NULL, NULL, NULL, NULL
FROM information_schema.sequences where sequence_schema='public'
ERROR: the column c.relhasoids does not exist;
There's any work around?
Last edited by CapitanoVlad (2020-03-18 11:28:32)
Offline
Pages: 1