On May 12, 2009, at 7:59 PM, Turner, Ian wrote:
CREATE TABLE foo (fooid integer);
Then I would also like to do
CREATE TABLE foo_audit (fooid integer, <other columns>);
along with the creation of some other triggers, rules, etc.
Is there any way to be notified when a user executes data definition
commands such as CREATE TABLE? It doesn't appear possible to apply
triggers or rules to the system tables, and the query rewrite engine
only seems to apply to SELECT, INSERT, and UPDATE. Thoughts?
Correct, there are no triggers on the system tables.
Maybe some type of cron process that ensures there is foo_audit for
table foo?
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
