OIDS in views

From: Zak McGregor <zak(at)mighty(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: OIDS in views
Date: 2001-06-13 02:26:00
Message-ID: 20010613042600.4f6376a7.zak@mighty.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I have a huge problem: I expect to find a column named 'oid' in any
table I query, and the client I am writing doesn't know whether I am
really selecting from a table or a view. Trying to create a view however
yields the following error:
ERROR: system column oid not available - mans is a view

and creating the view with
create view mans as select ....,oid from.... etc
gives the following error:

ERROR: Attribute 'oid' has a name conflict
Name matches an existing system attribute

Can I do anything about this, and does 7.1.2 perhaps not have this
problem?

I'm currently on 7.0.2.

Thanks

Cheers

Zak

--
Zak McGregor http://www.carfolio.com - Over 7000 car specs online
Web mercenary - currently for hire. Perl/html/.js/sql/cgi/GNUlinux/php +
---------------------------------------------------------------------
"Trying to make bits uncopyable is like trying to make water not wet.
The sooner people accept this, and build business models that take
this into account, the sooner people will start making money again."
-- Bruce Schneier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zak McGregor 2001-06-13 02:56:57 Re: OIDS in views
Previous Message Martijn van Oosterhout 2001-06-13 02:23:15 Re: Re: Does PostgreSQL support EXISTS?