Re: PostgreSQL error (new user) - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgreSQL error (new user)
Date
Msg-id 21727.1128373737@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL error (new user)  (Joshua Ort <elevenpast@yahoo.com>)
List pgsql-admin
Joshua Ort <elevenpast@yahoo.com> writes:
> I'm repeatedly getting the following error from
> dbDeveloper when trying to access my new 8.0.3
> database.

> ERROR: operator does not exist: pg_namespace -> oid

You should probably be asking the dbDeveloper folk about that.
I can easily think of queries that would provoke it, eg

regression=# select pg_namespace->oid from pg_namespace;
ERROR:  operator does not exist: pg_namespace -> oid

but not any *valid* query that would provoke it.  I'm wondering if
some bit of dbDeveloper is confused between C code and SQL code
and is thinking that it should write pg_namespace->oid when
pg_namespace.oid is really the proper syntax ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum Full Analyze Stalled
Next
From: Simon Riggs
Date:
Subject: Re: Vacuum Full Analyze Stalled