| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tim McAuley <mcauleyt(at)tcd(dot)ie> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: sequence's plpgsql |
| Date: | 2003-09-26 04:44:00 |
| Message-ID: | 8665.1064551440@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
Tim McAuley <mcauleyt(at)tcd(dot)ie> writes:
> I see from a previous email on the list that someone was able to get
> decent debug out of the locks, i.e.
> Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR: deadlock detected
> Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL: Proc 18735 waits
> for AccessExclusiveLock on relation 18028 of database 17140; blocked by
> How can I get this?
This display is a new feature in 7.4. Can you try your problem on a
7.4 beta release?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zhuangjifeng | 2003-09-26 05:43:38 | about catalog! |
| Previous Message | Dennis Gearon | 2003-09-26 02:34:16 | non local access to database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Natoli | 2003-09-26 05:57:55 | Re: Threads vs Processes |
| Previous Message | Tom Lane | 2003-09-26 04:14:32 | Re: Error message cleanup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Vezzoli | 2003-09-26 13:15:16 | Pgsql 7.3 JVM 1.1 driver missing |
| Previous Message | Barry Lind | 2003-09-26 04:13:15 | Re: problems installing 7.3.4 with java |