Re: stupid Q regarding "UPDATE waiting"

On Tue, Aug 27, 2002 at 02:08:17PM -0400, Andrew Sullivan wrote:

> > 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.

I see. One of the tables that are inserted into in the long-running
transaction references the table that gets updated in the "UPDATE waiting"
transaction. But the referencing column is always NULL on import.

Does that mean that there's a table-level lock? Can I get around this?

regards,

cm.
--
Christian Mock                          Wiedner Hauptstrasse 15
Senior Security Engineer                1040 Wien
CoreTEC IT Security Solutions GmbH      +43-1-5037273