Re: surprising trigger/foreign key interaction

Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:

> > I imagine this is so because of some old fiddling to get semantics just
> > right for obscure corner cases, but it feels wrong nevertheless.
> 
> I suspect it was reluctance to use the EvalPlanQual semantics (which
> are pretty bogus in their own way) for perfectly deterministic
> single-transaction cases.

I suspect the FK trigger messing up the visibility is an obscure corner
case too :-(

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support