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.

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@dcc.uchile.cl]
Sent: Tuesday, June 29, 2004 1:19 PM
To: Cason, Kenny
Cc: pgsql-hackers@postgresql.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.

"Cason, Kenny" <kenny.cason@boeing.com> writes:

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 "."

This error appears when I try to access ANY specific schema. Help!

Sounds like you're talking to an older server that doesn't understand
schemas. What does "select version()" return?

-Doug

On Tue, Jun 29, 2004 at 01:24:05PM -0700, Cason, Kenny wrote:

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?

Certainly ... at least this is not the 7.4.2 you just installed.

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:

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El d�a que dejes de cambiar dejar�s de vivir"

On Tue, 2004-06-29 at 21:24, Cason, Kenny wrote:

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?

Yes. You can get into problems if you have both an RPM version and a
compiled from source version on the same machine...

You may have accessed the RPM version when you thought you were
accessing the hand compiled one. Red Hat normally has some stuff on
there from earlier versions.

To check, select all packages, filtered by "postgres"
rpm -qa | grep postgres

You might then want to decide to de-install the earlier version, or at
least more strongly locate the one you just compiled.

Best regards, Simon Riggs