PostgreSQL OID Column on INSERT
Frank D. Engel, Jr.
fde101 at fjrhome.net
Tue Sep 28 15:38:45 EDT 2004
A while back I stumbled on a prior thread with this same question, but
I never did see a resolution to the root question.
When PostgreSQL performs an INSERT, it returns a unique OID number for
the inserted row. Is there any way to retrieve the OID value returned
by the INSERT statement from RevDB?
In my case, the other values, even in combination, are not guaranteed
unique -- except one, which is autogenerated by the database (a SERIAL
number), so there is no other way for me to be certain of grabbing the
exact record I just inserted, something I need to be able to do.
Thank you!
-----------------------------------------------------------
Frank D. Engel, Jr. <fde101 at fjrhome.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.
$
___________________________________________________________
$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
More information about the use-livecode
mailing list