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

Tue, 29 Jun 2004 12:07:30 -0700
"Cason, Kenny" <kenny.cason@boeing.com>
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 16:19:05 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Accessing Specific Schemas
"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

Tue, 29 Jun 2004 16:32:01 -0400
Doug McNaught <doug@mcnaught.org>
Re: Accessing Specific Schemas