Re: CREATE OR REPLACE TRIGGER not supported? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CREATE OR REPLACE TRIGGER not supported?
Date
Msg-id 27420.1095044419@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE OR REPLACE TRIGGER not supported?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: CREATE OR REPLACE TRIGGER not supported?  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Is threre any reason not to support "CREATE OR REPLACE"
>> only for triggers?

> Because the oid of a trigger doesn't matter.  You can go being; drop 
> trigger; create trigger; commit; atomically.

And how often do you need to redefine a trigger (as opposed to its
underlying function), anyway?

Sure, given infinite manpower we would support this.  But it seems very
far down the to-do list to me.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: CREATE OR REPLACE TRIGGER not supported?
Next
From: Satoshi Nagayasu
Date:
Subject: Re: CREATE OR REPLACE TRIGGER not supported?