Mike Nolan <[EMAIL PROTECTED]> writes: >> Where do you get that impression? currval() refers to the last ID for the >> session you are in. It's also FAQ question 4.15.3. Even better, if you >> havn't used nextval() in your current session, currval() returns an error, >> so you can't even get it wrong by accident.
> I stand corrected. I was doing some testing of a PHP module that is > called from a web form a while back and got inconsistent results with > currval, I probably had a script error of some kind. If you are using persistent connections in PHP you have to be very careful, because independent bits of PHP script may re-use the same database connection, and thereby will see a common currval value. After doing a nextval, you have to be sure to fetch currval before releasing the connection back to the pool. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org