Thread: 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_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
>
>

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
> > 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>