Re: mysql's last_insert_id - Mailing list pgsql-general

From Bruce Momjian
Subject Re: mysql's last_insert_id
Date
Msg-id 200309011647.h81Glbo15918@candle.pha.pa.us
Whole thread Raw
In response to Re: mysql's last_insert_id  (Bo Lorentsen <bl@netgroup.dk>)
Responses Re: mysql's last_insert_id
List pgsql-general
Bo Lorentsen wrote:
> On Fri, 2003-08-29 at 04:11, Martijn van Oosterhout wrote:
>
> > OIDs have never beebn unique, it's just that most databases never get big
> > enough to experience wraparound. They are also now optional per table and
> > may soon no longer be available by default.
> It would be a god idea to remove the oid reference from the FAQ
> 4.15.2, to make sure no one in the futhere makes my mistake again :-)

I have added the last clause to the FAQ:

    Finally, you could use the <A href="#4.16"><SMALL>OID</SMALL></A>
    returned from the <SMALL>INSERT</SMALL> statement to look up the
    default value, though this is probably the least portable approach,
    and the oid value will wrap around when it reaches 4 billion.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: French translation
Next
From: Bruce Momjian
Date:
Subject: Re: delivering database stand-alone