Re: Accessing Specific Schemas

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Accessing Specific Schemas
Date: 2004-06-29 20:32:01
Message-ID: 87k6xq2ji6.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Cason, Kenny" <kenny(dot)cason(at)boeing(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-06-29 20:39:07 PITR Error Message assistance
Previous Message Simon Riggs 2004-06-29 20:26:22 Re: lock timeout patch