pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL error (new user)
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL error (new user)
@ 2005-10-03 18:59 Joshua Ort <elevenpast@yahoo.com>
  2005-10-03 21:08 ` Re: PostgreSQL error (new user) Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Joshua Ort @ 2005-10-03 18:59 UTC (permalink / raw)
  To: pgsql-admin

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
HINT: No operator matches the given name and argument
type(s). You may need to add explicit type casts. 
---------------------------------------------------------

Any guidance here would be much appreciated.

Josh




		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL error (new user)
  2005-10-03 18:59 PostgreSQL error (new user) Joshua Ort <elevenpast@yahoo.com>
@ 2005-10-03 21:08 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-10-03 21:08 UTC (permalink / raw)
  To: Joshua Ort <elevenpast@yahoo.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-10-03 21:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-03 18:59 PostgreSQL error (new user) Joshua Ort <elevenpast@yahoo.com>
2005-10-03 21:08 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox