Re: default to WITHOUT OIDS? - Mailing list pgsql-hackers

From Neil Conway
Subject Re: default to WITHOUT OIDS?
Date
Msg-id 1042241157.743.17.camel@tokyo
Whole thread Raw
In response to Re: default to WITHOUT OIDS?  (Ashley Cambrell <ash@freaky-namuh.com>)
Responses Re: default to WITHOUT OIDS?
Re: default to WITHOUT OIDS?
List pgsql-hackers
On Fri, 2003-01-10 at 18:17, Ashley Cambrell wrote:
> The problem with getting rid of OIDs as default is there is then no way
> to get the primary key of a just inserted row with out OIDs (as far as I
> know)

Use currval() on the PK sequence -- if you call it from within the query
that inserted a row, it is guaranteed to give you the last sequence
value that it generated.

However, I agree that one of the drawbacks of this scheme would be
breaking the OID in the status string returned by INSERT and similar
commands. Not too big a deal, IMHO (users can still get the same effect
by specifying WITH OIDS, or toggling the GUC var)...

Cheers,

Neil
-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC





pgsql-hackers by date:

Previous
From: Ashley Cambrell
Date:
Subject: Re: default to WITHOUT OIDS?
Next
From: Tom Lane
Date:
Subject: Re: default to WITHOUT OIDS?