-----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@xxxxxxxxxxx>
$ 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
