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
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
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):
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
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
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
See:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/catalogs.html
for PostgreSQL 7.2.x, for 7.3 see:
http://developer.postgresql.org/docs/postgres/catalogs.html
Lee.
Steve Jackson writes:
> Hi
>
> Has anyone of you a good pointer to a description of where in the system
> t
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 tables and fields from a system table.
Thank you for your help in adv
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
Are the table structures of the System Tables changed often? Have they
changed from v7.1.1 and v7.1.2?
Peter
--
+---
| Data Architect
| your data; how you want it
| http://www.codebydesign.com
+---
---(end of broadcast)
10 matches
Mail list logo
