Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction blocking inserts in postgresql 7.3 - Mailing list pgsql-general

From Chris Hutchinson
Subject Re: transaction blocking inserts in postgresql 7.3
Date
Msg-id IDEOKBCDGGIDOBADNGAPAEAEDHAA.chris@hutchinsonsoftware.com
Whole thread Raw
In response to Re: transaction blocking inserts in postgresql 7.3  (Dennis Gearon <gearond@cvc.net>)
Responses Re: transaction blocking inserts in postgresql 7.3  (Dennis Gearon <gearond@cvc.net>)
Re: transaction blocking inserts in postgresql 7.3  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Issue with Rowid's during Oracle to Postgres convertion:
Next
From: dev@archonet.com
Date:
Subject: Re: Performance tuning in PostgreSQL