SqlDbx Forum

CapitanoVlad

Member

Object List empty with version 12

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)