Re: Need help. - Mailing list pgsql-hackers

I find such strange thing in my postgres server
-----------------------------------
distance=> \d cities;
********* QUERY **********
SELECT c.oid, n.nspname, c.relname
FROM pg_catalog.pg_class c    LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE pg_catalog.pg_table_is_visible(c.oid)     AND c.relname ~ '^cities$'
ORDER BY 2, 3;
**************************

ERROR:  parser: parse error at or near "."
-----------------------------------
distance=> SELECT c.oid,
distance->   n.nspname,
distance->   c.relname
distance-> FROM pg_catalog.pg_class c
distance->      LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
c.relnamespace
distance-> ;
ERROR:  parser: parse error at or near "."
-----------------------------------
distance=> SELECT c.oid,
distance->   c.relname
distance-> FROM pg_class c; oid  |             relname
-------+--------------------------------- 1247 | pg_type 1249 | pg_attribute16523 | pg_stat_user_indexes 1259 |
pg_class16526| pg_statio_all_indexes 1261 | pg_group 1262 | pg_database  376 | pg_xactlock16529 |
pg_statio_sys_indexes
........

So my database doesn't have pg_namespace system catalog, and doesn't
understand such "pg_catalog.pg_class c", but understand "pg_class c". May be
some of you have such problems with postgres and can help.

Thank you very much.


----- Original Message -----
From: "Petro Pelekh" <ppetro@mail.lviv.ua>
Newsgroups: comp.databases.postgresql.hackers
Sent: Friday, November 14, 2003 10:36 AM
Subject: Need help.


> Good morning,
>
>     I am new to Postgres, so excuse for such question, but I can't find it
> in dokumentation.
> I have table cities. I can insert into it, select from it, but cat run
such
> command
> distance=> \d cities
> ERROR:  parser: parse error at or near "."
>
>
> distance=> \d cities;
> ERROR:  parser: parse error at or near "."
>
> Can someone help me.
>
> Thank you very much
>
>

"Petro Pelekh" <ppetro@mail.lviv.ua> wrote in message
news:bp245r$2h93$1@news.uar.net...
> Good morning,
>
>     I am new to Postgres, so excuse for such question, but I can't find it
> in dokumentation.
> I have table cities. I can insert into it, select from it, but cat run
such
> command
> distance=> \d cities
> ERROR:  parser: parse error at or near "."
>
>
> distance=> \d cities;
> ERROR:  parser: parse error at or near "."
>
> Can someone help me.
>
> Thank you very much
>
>