Re: [HACKERS] System Tables and Triggers

2003-03-02 Thread Tom Lane
Stef Telford <[EMAIL PROTECTED]> writes: > This would seem to be a step backwards to me though, as > now we cant even put triggers on the system tables. Is there any > chance of this being lifted ? Not unless you can explain to us how it can be safe to fire arbitrary user-defined code when t

Re: [HACKERS] System Tables and Triggers

2003-03-02 Thread Hans-Jürgen Schönig
Hi Stef I had the same problem some time ago. I wanted to define a trigger firing on CREATE TABLE (pg_class). This won't work because in most cases system tables are not accessed using the "standard" way for processing queries (parse -> rewrite -> plan -> execute). Therefore triggers are not a