Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Simon Riggs
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

Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Alvaro Herrera
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 ... a

Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Alvaro Herrera
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 ne

Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Doug McNaught
"Cason, Kenny" <[EMAIL PROTECTED]> 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 erro

Re: [HACKERS] Accessing Specific Schemas

2004-06-29 Thread Cason, Kenny
Sent: Tuesday, June 29, 2004 1:19 PM To: Cason, Kenny Cc: [EMAIL PROTECTED] 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 someth

[HACKERS] Accessing Specific Schemas

2004-06-29 Thread Cason, Kenny
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!