| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Dann Corbit <DCorbit(at)connx(dot)com> |
| Cc: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>, techlist(at)voyager(dot)phys(dot)utk(dot)edu, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Duplicate key insert question |
| Date: | 2003-07-02 01:53:14 |
| Message-ID: | 20030702015314.GQ27363@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 01, 2003 at 06:48:29PM -0700, Dann Corbit wrote:
> I assume that PostgreSQL would simply time out both transactions if it
> happened in a deadly-embrace pair?
>
> I searched the PG docs, but could not find a clear answer.
No, the deadlock will the detected and one of the transactions will be
aborted. This should happen within a second or so (configurable,
AFAIR). The other transaction will continue normally.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El que vive para el futuro es un iluso, y el que vive para el pasado,
un imbécil" (Luis Adler, "Los tripulantes de la noche")
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-07-02 01:57:49 | Re: ERROR: language "c" is not trusted |
| Previous Message | Dann Corbit | 2003-07-02 01:48:29 | Re: Duplicate key insert question |