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

From Satoshi Nagayasu
Subject Re: CREATE OR REPLACE TRIGGER not supported?
Date
Msg-id 414552F8.8080409@nttdata.co.jp
Whole thread Raw
In response to Re: CREATE OR REPLACE TRIGGER not supported?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> And how often do you need to redefine a trigger (as opposed to its
> underlying function), anyway?

I just want to know why not supported.
It's not a serious problem.

Tom Lane wrote:
> 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
> 


-- 
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>
OpenSource Development Center,
NTT DATA Corp. http://www.nttdata.co.jp/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE OR REPLACE TRIGGER not supported?
Next
From: Sailesh Krishnamurthy
Date:
Subject: Re: APR 1.0 released