[sf-perl] PostgreSQL DBD ---- repost: sorry, I had the wrong subject in my previous post

Josh Berkus josh at agliodbs.com
Fri Apr 1 08:56:10 PST 2005


Dan,

> If you have multiple users of the database (ala, say, a web app),
> doing the
>
>    SELECT CURRVAL('table_id_seq')
>
> allows for another insert to sneak in between your insert and the
> select.

Only if those multiple users share a database connection (e.g. multi-threaded 
app).   CURRVAL is session-specific.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


More information about the SanFrancisco-pm mailing list