Re: Triggers and System Tables

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: Triggers and System Tables
Дата
Msg-id 11520385.1018969113@buzzer
обсуждение исходный текст
Ответ на Triggers and System Tables  (Hans-Juergen Schoenig <hs@cybertec.at>)
Список pgsql-general
Hi,

--On Montag, 15. April 2002 21:55 +0200 Hans-Juergen Schoenig
<hs@cybertec.at> wrote:

> I have a brief question concerning triggers and system tables:
> Why is it not allowed to trigger a system table? I guess it could be
> useful from time to time.

I guess it could be usefull to get an endless loop of trigger pulling
from time to time ;))

Imagine a trigger on the table which postgres uses for holding the trigger
data. Creating the trigger means action on the table, which in turn
pulls the trigger ...

Regardless of this I agree that it would be usefull - but one would
have to be _very_ carefully with the design of the trigger.

Regards
Tino Wildenhain

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

Предыдущее
От: CoL
Дата:
Сообщение: Re: speeding up subqueries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: R: I: Migrating a very large db