OIDS in views
От | Zak McGregor |
---|---|
Тема | OIDS in views |
Дата | |
Msg-id | 20010613042600.4f6376a7.zak@mighty.co.za обсуждение исходный текст |
Ответы |
Re: OIDS in views
|
Список | 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
В списке pgsql-general по дате отправления: