Re: Optimising Foreign Key checks - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Optimising Foreign Key checks
Date
Msg-id CAM-w4HNNoUp0PR10bzmj1=pbUvAioGqwJ3QTztT6wkvt2iLjKA@mail.gmail.com
Whole thread Raw
In response to Re: Optimising Foreign Key checks  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Optimising Foreign Key checks
List pgsql-hackers
On Sun, Jun 9, 2013 at 10:51 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> AFAICS there are weird cases where changing the way FKs execute will
> change the way complex trigger applications will execute. I don't see
> a way to avoid that other than "do nothing". Currently, we execute the
> checks following the normal order of execution rules for triggers.
> Every idea we've had so far changes that in some way; variously in
> major or minor ways, but changed nonetheless.

The obvious case to handle would be if someone has a trigger to
automatically create any missing references.


-- 
greg



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Batch API for After Triggers
Next
From: Kevin Grittner
Date:
Subject: Re: Vacuum, Freeze and Analyze: the big picture