OIDS in views
OIDS in views
От:
Zak McGregor <zak@mighty.co.za>
Дата:
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
Re: OIDS in views
От:
Zak McGregor <zak@mighty.co.za>
Дата:
On Wed, 13 Jun 2001 04:26:00 +0200 Zak McGregor wrote: > 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 [snip lots of rude stuff] Apologies all - I didn't mean to sound quite as rude as I did - I didn't realise until I re-read my email :( What I *meant* to say was: I have this problem (as per previous email ;-), does anyone please know any way that I can cause views to have a column with a name of 'oid' in them? Thanks very much Cheers all Zak The Over-Tired ;-) -- 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