Re: PostgreSQL error (new user)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joshua Ort <elevenpast(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL error (new user)
Date: 2005-10-03 21:08:57
Message-ID: 21727.1128373737@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joshua Ort <elevenpast(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-10-03 21:32:25 Re: Vacuum Full Analyze Stalled
Previous Message Tom Lane 2005-10-03 20:48:40 Re: Vacuum Full Analyze Stalled