Обсуждение: DROP TRIGGER in trigger

Поиск
Список
Период
Сортировка

DROP TRIGGER in trigger

От
Peter Chekunaev
Дата:
Hello!    I have a problem. Trigger changes data in the table of this    trigger. To avoid recursion I must disable
thistrigger or drop    it. As I know postgres doesn't support disabling triggers. In the    trigger I try drop it, but
postgresdoes nothing a long time and it    finishes only when I stop the postgres. What can I do to solve    this
problem?

Best regards,
Peter