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

[HACKERS] System Tables and Triggers

2003-03-01 Thread Stef Telford
Hello, First of all, kudos on postgreSQL. That being said, am having a slight problem with it, namely, System tables appear to be 'special tables' and disallow triggers. Perhaps its jst the way i am doing it, however, here is a rather trite example to illustrate (file called system.trig):