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 #