> From: Steve Baldwin [mailto:[EMAIL PROTECTED] > > LOCK TABLE user_table IN EXCLUSIVE MODE ; > SELECT MIN ... > INSERT INTO user_table ... > COMMIT ;
On 2004-09-14 14:53:06 -0600, Reidy, Ron wrote:
> Or ...
>
> SELECT MIN(id)
> FROM t
> FOR UPDATE;
>
> Would only cause a row lock.
Does that help in this case? The locked row isn't going to be updated,
but a new one is being inserted.
hp
--
_ | Peter J. Holzer | Shooting the users in the foot is bad.
|_|_) | Sysadmin WSR / LUGA | Giving them a gun isn't.
| | | [EMAIL PROTECTED] | -- Gordon Schumacher,
__/ | http://www.hjp.at/ | mozilla bug #84128
pgpzna8SJUVy4.pgp
Description: PGP signature
