Hi, this is a bit of a noob question.
I am using PGSql to perform some large analyses, with the clients being
a sequentially run set of perl scripts (one to set up and populate
tables and then down stream scripts to query the database for the
results).
During manual testing everything works, but automating it results in the
query scripts starting before the population transactions having
completed, so they give erroneous result.
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.
Can any one suggest where I should be looking, or if SET TRANSACTION is
the right way to go?
thanks