Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 200107182106.f6IL6kj11504@candle.pha.pa.us
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  ("Rod Taylor" <rbt@barchord.com>)
List pgsql-hackers
> If OIDs are dropped a mechanism for retrieving the primary key of the
> last insert would be greatly appreciated.  Heck, it would be useful
> now (rather than returning OID).
> 
> I much prefer retrieving the sequence number after the insert than
> before insert where the insert uses it.  Especially when trigger
> muckary is involved.

Doesn't currval() work for your needs.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: [HACKERS - GENERAL] PQexec() 8191 bytes limit and text fields
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: OID wraparound (was Re: pg_depend)