Re: CREATE OR REPLACE TRIGGER - Mailing list pgsql-patches

On Sun, 11 Aug 2002, Tom Lane wrote:

> Gavin Sherry <swm@linuxworld.com.au> writes:
> > Attached is a basic patch implementing create or replace trigger.
>
> Why would we need that, given that we now have CREATE OR REPLACE
> FUNCTION?  It's not like anything could depend on a trigger
> (other than FK constraints, and I don't think I want people replacing
> trigger definitions that are part of an FK constraint...)

I thought it conceivable that one may want to point the trigger at a
different function, change BEFORE or AFTER, or change the event(s) upon
which the trigger fires.

Gavin