Re: Deadlocks caused by referential integrity checks

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Deadlocks caused by referential integrity checks
Date: 2004-08-27 21:16:46
Message-ID: 412FA4BE.9070101@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
> 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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-08-27 21:47:49 Re: pg_autovacuum start-script
Previous Message Ennio-Sr 2004-08-27 21:01:32 [OT?] Problems with majordomo :-)