Postgres Pro
Downloads
Home   >   mailing lists

Re: how to ensure a client waits for a previous transaction to finish? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to ensure a client waits for a previous transaction to finish?
Date
Msg-id 24656.1260220361@sss.pgh.pa.us
Whole thread Raw
In response to how to ensure a client waits for a previous transaction to finish?  (Dan Kortschak <dan.kortschak@adelaide.edu.au>)
Responses Re: how to ensure a client waits for a previous transaction to finish?  (Dan Kortschak <dan.kortschak@adelaide.edu.au>)
List pgsql-general
Tree view 
Dan Kortschak <dan.kortschak@adelaide.edu.au> writes:
> How can I ensure the query scripts wait until the population transaction
> processes have finished? I've looked at 'SET TRANSACTION ISOLATION LEVEL
> SERIALIZABLE' (to us in the query scripts I thought), but I'm not sure
> that is what I want.

It's not.  What you want is to COMMIT and make sure you've gotten the
command completion response for that.  Possibly perl is complicating
matters with some sort of autocommit logic behind your back.

            regards, tom lane

pgsql-general by date:

Previous
From: Dan Kortschak
Date:
Subject: how to ensure a client waits for a previous transaction to finish?
Next
From: John R Pierce
Date:
Subject: Re: how to ensure a client waits for a previous transaction to finish?