Thread: psql problem querying relations

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
BY1,2;
 



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

Zoltan Boszormenyi wrote:
> 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

It's working for me. Have you tried with a fresh checkout or after 
running make clean before you build?

cheers

andrew

Andrew Dunstan írta:
> Zoltan Boszormenyi wrote:
>> 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
>
> It's working for me. Have you tried with a fresh checkout or after 
> running make clean before you build?
>
> cheers
>
> andrew

I have to reinitdb my test database then tried again.
It's working regardless of my IDENTITY patch is applied or not.
Thanks.