[HACKERS] psql problem querying relations

[Zoltan Boszormenyi]

Hi,

this is with current CVS code:
# \dt
ERROR:  did not find '}' at end of input node

Server log:

ERROR:  did not find '}' at end of input node
STATEMENT:  SELECT n.nspname as "Schema",
         c.relname as "Name",
         CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 
'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as 
"Type",
         r.rolname as "Owner"
       FROM pg_catalog.pg_class c
            JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
            LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
       WHERE c.relkind IN ('r','')
             AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
         AND pg_catalog.pg_table_is_visible(c.oid)
       ORDER BY 1,2;



Best regards,
Zoltán Böszörményi


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings