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

2009-05-27 Thread Turner, Ian
> From: Erik Jones [mailto:ejo...@engineyard.com] > Sent: Friday, May 15, 2009 6:19 PM > To: Turner, Ian > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Best way to monitor, control, or > rewrite data definition commands? > > > On May 14, 2009, at 2:38

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

2009-05-14 Thread Turner, Ian
;s privileges within a transaction, or to execute a command using another user's privileges? Thanks again for your thoughts. --Ian Turner > -Original Message- > From: Greg Smith [mailto:gsm...@gregsmith.com] > Sent: Tuesday, May 12, 2009 9:50 PM > To: Turner, Ian > Cc

[GENERAL] Best way to monitor, control, or rewrite data definition commands?

2009-05-12 Thread Turner, Ian
Hello list, I am trying to implement automatic audit log tracking for newly created tables. When a user creates a table, I would like to create a second table for the audit log, along with the relevant rules. So for example, if a user does CREATE TABLE foo (fooid integer); Then I would also like