| From: | cm(at)coretec(dot)at (Christian Mock) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Subject: | Re: stupid Q regarding "UPDATE waiting" |
| Date: | 2002-08-28 10:38:21 |
| Message-ID: | 20020828103821.GA11523@notemock.coretec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Weilguni | 2002-08-28 10:44:14 | Re: Data files became huge with no apparent reason |
| Previous Message | Chris Lee | 2002-08-28 09:50:45 | Data Type |