Re: [GENERAL] sequences vs oids as primary keys

2006-07-26 Thread Merlin Moncure
On 7/25/06, Kenneth Downs <[EMAIL PROTECTED]> wrote: craigp wrote: >1) does it make sense (and would it be possible) to make a rule which would, >say, somehow write into the oid field of a tuple to be returned by lastoid? i'm >assuming here that the database would not have oid's enabled. > > > W

Re: [GENERAL] sequences vs oids as primary keys

2006-07-25 Thread Kenneth Downs
craigp wrote: 1) does it make sense (and would it be possible) to make a rule which would, say, somehow write into the oid field of a tuple to be returned by lastoid? i'm assuming here that the database would not have oid's enabled. We do this in a trigger. We assign the NEXTVAL to a variab

Re: [GENERAL] sequences vs oids as primary keys

2006-07-25 Thread Richard Huxton
craigp wrote: i had some questions/thoughts on using sequences vs oids as pks... it's a common requirement to obtain the last value of a sequence after an insert. most other databases support such a feature, but since oid's are deprecated, and only oid's are returned, this isn't supported by post