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