Thread: Accessing Specific Schemas
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! Kenny Cason The Boeing Company Kenny.cason@boeing.com
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 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.
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