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: | Raw Message | Whole Thread | 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 |