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

From Tom Lane
Subject Re: CREATE OR REPLACE TRIGGER
Date
Msg-id 13310.1029081227@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE OR REPLACE TRIGGER  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: CREATE OR REPLACE TRIGGER
Re: CREATE OR REPLACE TRIGGER
List pgsql-patches
Gavin Sherry <swm@linuxworld.com.au> writes:
> From memory, I think some of the pgadmin guys jumped up and down about it
> for a while: http://fts.postgresql.org/db/mw/msg.html?mid=1353289.

Hmm.  I remember Poure asking repeatedly for CREATE OR REPLACE VIEW,
and that makes a lot of sense to me, because other things *can* depend
on a view.  (Unfortunately, by the same token it's a lot harder to do.)
The use-case for replacing a trigger is not visible to the naked eye.

            regards, tom lane

pgsql-patches by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: CREATE OR REPLACE TRIGGER
Next
From: Gavin Sherry
Date:
Subject: Re: CREATE OR REPLACE TRIGGER