Re: Foreign key bugs (Re: [BUGS] "New" bug?? Serious - crashesbackend.)

Tom Lane wrote:
> "Stephan Szabo" <sszabo(at)kick(dot)com> writes:
> > Also, I realized something else that is a little wierd. When a temporary
> > table shadows a permanent table that you've made a foreign key reference
> > to, which table should it be going to check the constraint?
>
> Seems to me it should certainly be going to the permanent table, which
> is another argument in favor of making the link via OID not table name.
> The existing code will get this wrong.

But even if the trigger knows the OID of the table to query,
can it prepare a plan to do so via SPI? I think no.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #