Re: stupid Q regarding "UPDATE waiting" - Mailing list pgsql-general

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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110