Re: sequences vs oids as primary keys - Mailing list pgsql-general

From Kenneth Downs
Subject Re: sequences vs oids as primary keys
Date
Msg-id 44C60FD8.2080302@secdat.com
Whole thread Raw
In response to sequences vs oids as primary keys  (craigp <craigp98072@yahoo.com>)
Responses Re: sequences vs oids as primary keys  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
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 variable, write
that to the row, then raise its value as a notice.  Then we just
retrieve the notice.

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: gmake Errors: pg_backup_archiver.c: undefined reference to `lo_create'
Next
From: Wes
Date:
Subject: Re: Lock changes with 8.1 - what's the right lock?