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

[Jan Wieck]

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.                                  #
#================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend