Re: Triggers and System Tables - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Triggers and System Tables
Date
Msg-id 11520385.1018969113@buzzer
Whole thread Raw
In response to Triggers and System Tables  (Hans-Juergen Schoenig <hs@cybertec.at>)
List 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 by date:

Previous
From: CoL
Date:
Subject: Re: speeding up subqueries
Next
From: Tom Lane
Date:
Subject: Re: R: I: Migrating a very large db