The light now glows above my head. OTOH, i thought that with a MVCC transaction
model, the scenario you describe should not be possible.
Chris Hutchinson wrote:
> Dennis,
>
>
>>I'm really curious how you got these two transactions to occur
>>simultaneously, i.e. how does one DO the test that you DID?
>
>
> Open two terminal sessions, run a copy of psql in both. In one run the 'begin; insert...', in the other run 'insert'. The second is blocked until a commit (or rollback) is entered in the first.
>
> Regards,
> Chris
>
>
>