Re: how to ensure a client waits for a previous transaction to finish?

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