Re: TCL trigger doesn't work after deleting a column

Поиск
Список
Период
Сортировка
От Josué Maldonado
Тема Re: TCL trigger doesn't work after deleting a column
Дата
Msg-id 3F565D45.70202@lamundial.hn
обсуждение исходный текст
Ответ на TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
Ответы Re: TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
Список pgsql-general
Hi Darren,

darren@crystalballinc.com wrote:

>From what i am seeing / thinking did you drop it from the table ???
>
> I am assuming yes and therefore you should recreate the function and the
> trigger and you should be fine.
>
> Using 7.3.x use the CREATE OR REPLACE FUNCTION to replace the function so
> it will still have the same OID.
>
> Next drop the trigger and then recreate the trigger and you should be fine

Did that, and still got the same error. I'm currently preparing the
server to update to 7.3.4 I hope this could help.

Thanks



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

Предыдущее
От: Adam Kavan
Дата:
Сообщение: Re: Index not being used ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using oids