hello,
I'm doing long-running transactions which insert into tables A and B,
and when I try to update table C from another session, the update
hangs until the first transaction is done; the related postgres process
shows as "UPDATE waiting" in ps.
Why is this, and is there a way around it?
tnx,
cm.
--
Christian Mock Wiedner Hauptstrasse 15
Senior Security Engineer 1040 Wien
CoreTEC IT Security Solutions GmbH +43-1-5037273