Re: a trigger question

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: a trigger question
Дата
Msg-id Pine.LNX.4.44.0206061607500.2224-100000@cm-lcon-46-187.cm.vtr.net
обсуждение исходный текст
Ответ на Re: a trigger question  ("Gregory Wood" <gregw@com-stock.com>)
Список pgsql-general
El Jun 6, Gregory Wood escribio:

> Sounds like you did a CREATE FUNCTION, then a CREATE TRIGGER, then needed to
> DROP and reCREATE your function. The trigger is still looking for the old
> function, try DROP TRIGGER and CREATE TRIGGER again to make sure it points
> to the current version.

Also remember that you can just CREATE OR REPLACE the function so that
you don't have to drop and recreate the trigger afterwards.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: how to remove columns from a table
Следующее
От: "Tyler Mitchell"
Дата:
Сообщение: Demo versions