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@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

On Fri, Nov 14, 2003 at 02:04:56PM +0200, Petro Pelekh wrote:

I find such strange thing in my postgres server
-----------------------------------
distance=> \d cities;
ERROR: parser: parse error at or near "."

You are using psql from a 7.3 version to talk to an older server. This
is not guaranteed to work. It is recommended to upgrade the server, or
downgrade the tool.

Try
SELECT version();

and psql --version

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Just treat us the way you want to be treated + some extra allowance
for ignorance." (Michael Brusser)

On Fri, Nov 14, 2003 at 14:04:56 +0200,
Petro Pelekh <ppetro@mail.lviv.ua> wrote:

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.

It looks like the client and the server aren't from the same version
of postgres.

Thank you very much, for help.

The problem was, that the server and client wasn't the same version.

"Bruno Wolff III" <bruno@wolff.to> wrote in message
news:20031114182958.GA4999@wolff.to...

On Fri, Nov 14, 2003 at 14:04:56 +0200,
Petro Pelekh <ppetro@mail.lviv.ua> wrote:

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