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