Обсуждение: psql problem querying relations

Поиск
Список
Период
Сортировка

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



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



Re: psql problem querying relations

От
Andrew Dunstan
Дата:
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


Re: psql problem querying relations

От
Zoltan Boszormenyi
Дата:
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.