Re: Need help.

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_attribute
16523 | pg_stat_user_indexes
1259 | pg_class
16526 | pg_statio_all_indexes
1261 | pg_group
1262 | pg_database
376 | pg_xactlock
16529 | 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(at)mail(dot)lviv(dot)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(at)mail(dot)lviv(dot)ua> wrote in message
news:bp245r$2h93$1(at)news(dot)uar(dot)net(dot)(dot)(dot)
> 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
>
>