On 2010-01-07 18:13 +0200, Marko Tiikkaja wrote:
I had a similar syntax in mind, but instead of using threads, just execute the file in order using asynchronous connections.
I completely failed to make the point here which was to somehow mark which statements will (or, should) block. So here we go:
A=> BEGIN; B=> BEGIN; A=> UPDATE foo ..; &B=> UPDATE foo ..; -- this will block A=> COMMIT; B=> SELECT * FROM foo; B=> COMMIT; [expected output here] Regards, Marko Tiikkaja -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
