Horton

Re: Deadlocks caused by referential integrity checks

Joshua D. Drake <jd@commandprompt.com>

View thread View on postgr.es
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Vivek Khera <khera@kcilink.com>
Cc: pgsql-general@postgresql.org
Date: 2004-08-27T21:16:46Z
Lists: pgsql-general

Attachments

> 
> If PG had a way for me to tell it the action logger transaction was
> "less important" and should be the one killed, I'd live with that,
> since the other transaction is usually more expensive.
> 

Hello set the check deferrable.


> 
> 


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL