Re: Deadlocks caused by a foreign key constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: dmitry(at)koterov(dot)ru, "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deadlocks caused by a foreign key constraint
Date: 2007-08-16 05:21:43
Message-ID: 17489.1187241703@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Decibel! <decibel(at)decibel(dot)org> writes:
> But... taking a quick look at RI_FKey_check in backend/utils/adt/
> ri_triggers.c, I don't see it checking to see if the FK has changed,
> which seems odd. I would think that if the FK fields haven't changed
> that there's no need to perform the check.

You looked in the wrong place; see AfterTriggerSaveEvent in
commands/trigger.c

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-16 05:28:11 Re: User-Friendly TimeZone List
Previous Message Rodrigo De León 2007-08-16 05:21:29 Re: Fastest way to import only ONE column into a table? (COPY doesn't work)