On or about Wed, Jul 17, 2002 at 11:33:10AM +0100, Peter Haworth typed: >Postgres sequences dont get rolled back with transactions, either. Since >this is a good thing, the same is probably true of all those other databases >I haven't used. Without these protections, a transaction would need >exclusive access to the sequence, which forces serialisation. If you want >that, you can implement it yourself easily enough.
Usually with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE. :-) Roger