From: stef@chronozon.artofdns.com
To: pgsql-sql@postgresql.org
Subject: Triggers and System Tables.
Date: Mon, 27 May 2002 18:46:50 -0400 (EDT)
Message-ID: <20020527224650.0A27E8AEA@chronozon.artofdns.com> (raw)
Hello,
this is probably a really silly question, but where can i
control wether or not the superuser/root user can create a trigger
on a system table ?
Currently, have been tinkering with the idea of adding
in the ability to have 'session variables' for the connection, so
that before a transaction it can declare and save variables, so
that they can be used in the transaction themselves. This would
ease some problems i have with inheritance. It also would make
some sort of connection limiting per user a lot easier if it was
possible to attach triggers to pg_stat_activity (on INSERT only :)
So, the real question is, is this a question for hackers
mailing list or can anyone tell me how to drop the limitation ?
many thanks
Stef
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: stef@chronozon.artofdns.com
Subject: Re: Triggers and System Tables.
In-Reply-To: <20020527224650.0A27E8AEA@chronozon.artofdns.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox