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

Re: [HACKERS] System Tables

2002-11-28 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: >> Has anyone of you a good pointer to a description of where in the system >> tables I may find what informations? > The PostgreSQL Developer's Guide has some information: > http://developer.postgresql.org/docs/postgres/catalogs.html > But IIRC it mig

Re: [HACKERS] System Tables

2002-11-28 Thread Andrew J. Kopciuch
On Thursday 28 November 2002 00:32, Steve Jackson wrote: > Hi > > Has anyone of you a good pointer to a description of where in the system > tables I may find what informations? I try to code a generic procedure > which gets information (like field type, field length, foreign keys...) > about table

Re: [HACKERS] System Tables

2002-11-28 Thread Neil Conway
On Thu, 2002-11-28 at 02:32, Steve Jackson wrote: > Has anyone of you a good pointer to a description of where in the system > tables I may find what informations? The PostgreSQL Developer's Guide has some information: http://developer.postgresql.org/docs/postgres/catalogs.html But IIRC it

Re: [HACKERS] System Tables

2001-09-14 Thread Peter Eisentraut
Peter Harvey writes: > Are the table structures of the System Tables changed often? Only between major releases (if necessary). > Have they changed from v7.1.1 and v7.1.2? No. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of bro