On Tue, Aug 27, 2002 at 07:40:09PM +0200, Christian Mock wrote:
> 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.
Do you have referential integrity on any of these? That's the usual
suspect in these cases.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110