[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Moshe Weitzman]

> Without pconnect, the connection closes at the end of the script's  
> execution.  With pconnect, the connection stays open for use by a  
> subsequent request using that process.  Subsequent != concurrent, so  
> you shouldn't be seeing any race conditions or multiple processes  using 
> a connection at the same time.

OK then. Lets ditch those home grown sequences and make use of 
auto-increment/serial/identity fields.