Re: CREATE OR REPLACE TRIGGER not supported?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE OR REPLACE TRIGGER not supported?
Дата
Msg-id 27420.1095044419@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CREATE OR REPLACE TRIGGER not supported?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: CREATE OR REPLACE TRIGGER not supported?  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: CREATE OR REPLACE TRIGGER not supported?
Следующее
От: Satoshi Nagayasu
Дата:
Сообщение: Re: CREATE OR REPLACE TRIGGER not supported?