dbi_pgsql_return_rowid_from_insert

This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.



To: James Maes <jmaes@sportingnews.com>
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
Subject: Re: Postgresql 7.0.3 
Date: Mon, 15 Jan 2001 01:20:19 -0500 (EST)

On Sun, 14 Jan 2001, James Maes wrote:

> Is there anyway to return the result of a insert to a serial column in
> Postgres or DBD:Pg?

Yes, "SELECT currval('seq_name')" will give you the last value used in a
sequence, (implicitly created by the SERIAL declaration), where the
sequence is the column name with _seq appended.

((Does this work if multiple processes are doing inserts?
Sounds like a race-condition, but maybe some sort of
transaction magic covers the problem.  Ask on PGSQL list
some time?  -- doom ))


===

To: "James Maes" <jmaes@sportingnews.com>, "DBI"
<dbi-users@isc.org>
From: "Michael Mayo" <michael-a-mayo@worldnet.att.net>
Subject: Re: Postgresql 7.0.3 
Date: Mon, 15 Jan 2001 00:01:57 -0500

----- Original Message -----
From: "James Maes" <jmaes@sportingnews.com>
> Is there anyway to return the result of a insert to a serial column in
> Postgres or DBD:Pg?

Nope.  You have to do SELECT nextval('sequence_name') then
use the result in your future queries.

===

the rest of The Pile (a partial mailing list archive)

doom@kzsu.stanford.edu