Re: Triggers for FK on Views - can they be made deferrable?

There is a way to create them as CONSTRAINT triggers. It's totally
non-standard, not guaranteed to exist in future releases, yadda, yadda.
But it get's you where you want to be now().


Jan

ezra epstein wrote:

> I've got the case of a table which has unusual FK constraints.  I'm
> implementing them as triggers against a view.  It all works, BUT I don't see
> a way to make the triggers executed only on Commit -- i.e., I'd like the
> same "deferrable" behavior that true FKs provide.  Does anyone know how to
> do this?
>
> Thanks,
>
> Ezra E.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


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