Quick Links

Re: transaction blocking inserts in postgresql 7.3

From:	"Chris Hutchinson" <chris(at)hutchinsonsoftware(dot)com>
To:	"Dennis Gearon" <gearond(at)cvc(dot)net>
Cc:	<pgsql-general(at)postgresql(dot)org>
Subject:	Re: transaction blocking inserts in postgresql 7.3
Date:	2003-03-26 07:32:52
Message-ID:	IDEOKBCDGGIDOBADNGAPAEAEDHAA.chris@hutchinsonsoftware.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Re: transaction blocking inserts in postgresql 7.3 at 2003-03-26 05:51:48 from Dennis Gearon

Responses

Re: transaction blocking inserts in postgresql 7.3 at 2003-03-26 15:39:42 from Dennis Gearon
Re: transaction blocking inserts in postgresql 7.3 at 2003-03-26 19:50:46 from Dennis Gearon

Browse pgsql-general by date

	From	Date	Subject
Next Message	dev	2003-03-26 07:53:56	Re: Performance tuning in PostgreSQL
Previous Message	Jules Alberts	2003-03-26 07:15:30	Re: to suspend constraints