Re: GetLastInsertID ? - Mailing list pgsql-general

From Tom Lane
Subject Re: GetLastInsertID ?
Date
Msg-id 21842.1073279950@sss.pgh.pa.us
Whole thread Raw
In response to Re: GetLastInsertID ?  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
Doug McNaught <doug@mcnaught.org> writes:
> Mike Nolan <nolan@gw.tssi.com> writes:
>> Is currval for each process maintained at the front end (e.g., the PHP or
>> psql connection) or at the back end?

The latter.

>> If the latter, isn't there always
>> the potential for memory overflows or other high-demand situations causing
>> the pairing of nextval/currval to get corrupted or lost, in which case
>> RELYING upon it for the last key value could be a source of problems.

> How, exactly, would this happen?  Is this worry based on an analysis
> of the source code, or just speculation?

Perhaps more to the point, what in the world makes you think that
storage at the front end would be safer?  The backend we have some
control over.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: why the need for is null?
Next
From: Tom Lane
Date:
Subject: Re: altering a column