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

Tom Lane wrote:
> "Stephan Szabo" <sszabo@kick.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@Yahoo.com #