From: | Si Chen <schen(at)graciousstyle(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [ADMIN] how to find transaction associated with a lock |
Date: | 2004-07-26 16:38:06 |
Message-ID: | 4105336E.4030604@graciousstyle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-novice |
Hi Tom,
Thanks for your help last week. I had the problem again where things
got hung up during a transaction, and it was at the order_header table.
Here is what the pg_locks show. Does it confirm what you are saying,
which is that multiple transactions have tried to insert into this table?
Thanks,
Si
>
>
Attachment | Content-Type | Size |
---|---|---|
locks.txt | text/plain | 11.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-07-26 16:42:57 | Re: [ADMIN] how to find transaction associated with a lock |
Previous Message | Christian Hache | 2004-07-26 12:27:30 | Ayuda con pg_resotre |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2004-07-26 16:41:44 | Re: Sql injection attacks |
Previous Message | Bill Moran | 2004-07-26 16:22:42 | Re: Sql injection attacks |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-07-26 16:42:57 | Re: [ADMIN] how to find transaction associated with a lock |
Previous Message | Marc G. Fournier | 2004-07-26 16:29:02 | Re: Request for information about 3rd party support for |