Re: CREATE OR REPLACE TRIGGER

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: CREATE OR REPLACE TRIGGER
Дата
Msg-id Pine.LNX.4.21.0208120105040.14282-100000@linuxworld.com.au
обсуждение исходный текст
Ответ на Re: CREATE OR REPLACE TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CREATE OR REPLACE TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-patches по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: stand-alone composite types patch (was [HACKERS] Proposal:
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATE OR REPLACE TRIGGER