Re: [PERFORM] pl/pgsql and Transaction Isolation

2004-06-08 Thread Marcus Whitney
You were right not to believe it. I had an update on a whole table that I hadn't noticed. Thanks for debunking. On Monday 07 June 2004 23:29, you wrote: > Marcus Whitney <[EMAIL PROTECTED]> writes: > > I have an instance where I have a series of pl/pgsql calls, that report > > stat results to

Re: [PERFORM] pl/pgsql and Transaction Isolation

2004-06-07 Thread Tom Lane
Marcus Whitney <[EMAIL PROTECTED]> writes: > I have an instance where I have a series of pl/pgsql calls, that report stat > results to a common table. When other queries try to hit the stat table > (with DML commands; SELECT, INSERT, UPDATE, DELETE etc.) they are forced to > wait in a queue u

[PERFORM] pl/pgsql and Transaction Isolation

2004-06-07 Thread Marcus Whitney
Hello, I have an instance where I have a series of pl/pgsql calls, that report stat results to a common table. When other queries try to hit the stat table (with DML commands; SELECT, INSERT, UPDATE, DELETE etc.) they are forced to wait in a queue until the pl/pgsql has finished executing.