Re: transaction blocking inserts in postgresql 7.3

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'.
Thesecond is blocked until a commit (or rollback) is entered in the first. 
>
> Regards,
> Chris
>
>
>