Re: OIDS in views

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

On Wed, 13 Jun 2001 04:26:00 +0200
Zak McGregor <zak(at)mighty(dot)co(dot)za> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message KuroiNeko 2001-06-13 04:28:47 Re: Re: Does PostgreSQL support EXISTS?
Previous Message Zak McGregor 2001-06-13 02:26:00 OIDS in views