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



Fri, 14 Nov 2003 10:36:11 +0200
"Petro Pelekh" <ppetro@mail.lviv.ua>
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
> 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
>
>



Fri, 14 Nov 2003 14:04:56 +0200
"Petro Pelekh" <ppetro@mail.lviv.ua>
Re: Need help.
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)

Fri, 14 Nov 2003 15:27:32 -0300
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Need help.
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.

Fri, 14 Nov 2003 12:29:58 -0600
Bruno Wolff III <bruno@wolff.to>
Re: Need help.
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
>



Mon, 17 Nov 2003 09:55:14 +0200
"Petro Pelekh" <ppetro@mail.lviv.ua>
Re: Need help.