| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Hans-Juergen Schoenig <hs(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Triggers and System Tables |
| Date: | 2002-04-16 12:58:41 |
| Message-ID: | 11520385.1018969113@buzzer |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
--On Montag, 15. April 2002 21:55 +0200 Hans-Juergen Schoenig
<hs(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-16 13:06:36 | Re: R: I: Migrating a very large db |
| Previous Message | Marc G. Fournier | 2002-04-16 12:41:19 | Testers needed ... |