Export a column in a view without "announcing" it?

From: "Frank D(dot) Engel, Jr(dot)" <fde101(at)fjrhome(dot)net>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Export a column in a view without "announcing" it?
Date: 2005-01-26 16:10:07
Message-ID: BF620526-6FB4-11D9-B323-0050E410655F@fjrhome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm fairly certain there is currently no way to do this, but it would
make life a bit easier for me right now if there were, so I guess I'm
going to ask it anyway, just in case:

Is there any way to expose a column in a view without "announcing" the
fact that it is there? Specifically, in order to support updatable
cursors on views (faked ones, using the ODBC driver), it is necessary
to include the underlying table's OID and CTID columns in the view; but
the client software I am trying to use then chokes on there being a
column named OID (which is present, but hidden, if I use a table). So
basically I would like to do:

CREATE VIEW aView AS
SELECT x, y, OID, CTID, z, t, ... FROM aTable WHERE condition_met
WITHOUT ANNOUNCING OID, CTID

or some such, so that if a query requesting OID or CTID is made, it
will be there, while if a client asks for a list of columns, OID and
CTID are not given?

Also: with respect to the "fake" updatable cursors: if the client
program attempts an INSERT operation and does not provide values for
OID and CTID, am I correct in assuming that the database will correctly
fill in these columns automatically?

Thank you!

- -----------------------------------------------------------
Frank D. Engel, Jr. <fde101(at)fjrhome(dot)net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB98Dg7aqtWrR9cZoRAhQZAJ9YcDwir3mvcPESGEuduVHWIeXfzwCeMO/+
iQ7q3x86VNjjpoywOXr4KJ4=
=uROx
-----END PGP SIGNATURE-----

___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-26 16:15:55 Re: backslashes in queries containing LIKE
Previous Message Max 2005-01-26 16:00:36 Splitting queries across servers