Re: Best way to monitor, control, or rewrite data definition commands?

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.