On Mon, March 19, 2007 10:58 pm, markw@xxxxxxxxxxxxxx wrote: >> markw@xxxxxxxxxxxxxx wrote: >>>> markw@xxxxxxxxxxxxxx wrote: >>>>>> On Sat, 2007-03-17 at 12:19 -0400, Mark wrote: >> Check the documentation - currval returns the last one *for that >> session* - it does not return the last global change. >> >> http://www.postgresql.org/docs/current/static/functions-sequence.html >> >> It is perfectly safe to use this. > > In theory that may be true, but can the application developer make any > assumption about the underlying architecture? Might you be familiar > with > connection pooling? Where multiple threads or processes share a > database > connection or "session?" If the pool breaks the documentation about current session, the pool is broken. Fix it. :-) I don't think the "pool" will give you somebody else's ID, for the record. It's smart enough to not do that, I *believe*, mostly on faith. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
