Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock when one process opens two separate connections? - Mailing list pgsql-general

From Florian Weimer
Subject Re: Deadlock when one process opens two separate connections?
Date
Msg-id 82fyeekiaq.fsf@mid.bfk.de
Whole thread Raw
In response to Deadlock when one process opens two separate connections?  (Kaloyan Iliev <news1@faith.digsys.bg>)
List pgsql-general
Tree view 
* Kaloyan Iliev:

> Probbly beacause both transactions started from one process?

Yes, the deadlock detector isn't psychic.  It can't know about lock
ordering constraints which are external to PostgreSQL.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99

pgsql-general by date:

Previous
From: Kaloyan Iliev
Date:
Subject: Deadlock when one process opens two separate connections?
Next
From: Jon Lapham
Date:
Subject: Restart after power outage: createdb