Re: Is this correct behavior for ON DELETE rule? - Mailing list pgsql-general

"Rick Schumeyer" <rschumeyer@ieee.org> writes:
> Would some combination of triggers work instead?

Nope, you can't put triggers on a view, sorry.  In theory a BEFORE
INSERT trigger would be a workable alternative to an ON INSERT rule
for redirecting insertions.  (I think we disallow it at the moment
though.)  But UPDATE and DELETE triggers can't work because the view
doesn't actually contain any physical tuples and so there is nothing
for the triggers to fire on.

            regards, tom lane