On Tue, Feb 13, 2001 at 09:56:18AM -0000, Michael Ansley wrote:
> Hi,
>
> Well, the number is 'locked', because once it's given to you, that's it,
> it's gone from the 'list of available numbers' (i.e.: the sequence).
> However, between the insert, and the read of the ID, if another transaction
> performs an insert, it does NOT affect the ID that the first transaction
> reads (i.e.: your ID read in the first transaction IS definitely still safe,
> it will still read the correct one).
I understand this.
> AND, the first insert does NOT block
> the second insert. The second insert could complete and commit before the
> first one.
But I don't know how to reproduce this part.
If I have two different sessions of psql connected to same database:
psql-1# begin;
psql-2# begin;
psql-1# insert into foo ...;
psql-2# insert into foo ...; <- ˇˇˇFrozen!!!
psql-1# commit; <- psql-2 unfrozen
Why I get this?.
> Does this explain better?
Very well, thanks ;)
David
