From: | "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Accessing Specific Schemas |
Date: | 2004-06-29 20:24:05 |
Message-ID: | B96DB973FD58EE469E4426886240EE970231E35C@xch-nw-03.nw.nos.boeing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0.3.2-7)
(1 row)
Hmmm... Makes me think I'm accessing the wrong version of PostgreSQL. Does that sound likely?
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)dcc(dot)uchile(dot)cl]
Sent: Tuesday, June 29, 2004 1:19 PM
To: Cason, Kenny
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Accessing Specific Schemas
On Tue, Jun 29, 2004 at 12:07:30PM -0700, Cason, Kenny wrote:
> I'm having trouble accessing specific schemas and wonder if maybe I
> haven't installed something properly in 7.4.2. Here is what is
> happening:
>
> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
>
> ERROR: parser: parse error at or near "."
Looks like your server doesn't have schema support at all ... what does "select version()" give you?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
www.google.com: interfaz de línea de comando para la web.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2004-06-29 20:26:22 | Re: lock timeout patch |
Previous Message | Alvaro Herrera | 2004-06-29 20:19:05 | Re: Accessing Specific Schemas |