[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] =?utf-8?B?c2VxdWVuY2UgbnVtYmVycyB1bmRlciBwZyBjb25jdXJyZW5jZSBtb2RlbA==?=
From:       scorpdaddy () hotmail ! com <scorpdaddy () hotmail ! com>
Date:       2011-02-24 19:49:02
Message-ID: BLU0-SMTP1820FE6B2BC38FE48BB45D0CEDA0 () phx ! gbl
[Download RAW message or body]

[Attachment #2 (text/plain)]

What is the expected behaviour of sequence numbers under pg concurrence model? E.g.  \
Uncommitted transaction 1 in progress has inserted 5 tuples into table foo.  \
Meanwhile uncommitted transaction 2 in progress inserts 100 tuples into table foo.  \
If the sequence number for the pk started at 1000 before these transactions, what are \
the sequence numbers for transaction 1, 2, and the final sequence number if they both \
commit?  One rollback's?  Both rollback? One hangs open while the other commits?  One \
hang and one rollback's?


[Attachment #3 (text/html)]

What is the expected behaviour of sequence numbers under pg concurrence model? E.g.  \
Uncommitted transaction 1 in progress has inserted 5 tuples into table foo.  \
Meanwhile uncommitted transaction 2 in progress inserts 100 tuples into table foo.  \
If the sequence number for the pk started at 1000 before these transactions, what are \
the sequence numbers for transaction 1, 2, and the final sequence number if they both \
commit?  One rollback&#39;s?  Both rollback? One hangs open while the other commits?  \
One hang and one rollback&#39;s?<br><br>



[prev in list] [next in list] [prev in thread] [next in thread]