From: | "Petro Pelekh" <ppetro(at)mail(dot)lviv(dot)ua> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Need help. |
Date: | 2003-11-14 12:04:56 |
Message-ID: | bp2gd8$2o86$1@news.uar.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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_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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2003-11-14 12:27:51 | Re: heads up -- subtle change of behavior of new initdb |
Previous Message | Peter Eisentraut | 2003-11-14 10:42:02 | Re: Problem with compilation 7.3.4 |