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.


Tue, 29 Jun 2004 13:24:05 -0700
"Cason, Kenny" <kenny.cason@boeing.com>
Re: Accessing Specific Schemas
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"


Tue, 29 Jun 2004 16:56:06 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Accessing Specific Schemas
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




Wed, 30 Jun 2004 01:27:07 +0100
Simon Riggs <simon@2ndquadrant.com>
Re: Accessing Specific Schemas