Re: [GENERAL] Select Column Auditing/Logging

2009-07-22 Thread Sam Mason
On Wed, Jul 22, 2009 at 02:41:41PM -0700, Jeff Davis wrote: > On Wed, 2009-07-22 at 12:04 -0700, Jeremy Brown wrote: > > It seems that PostgreSQL can audit INSERT, UPDATE, DELETE, and > > TRUNCATE through the use of triggers. But SELECT triggers are > > unsupported (it does suggest perhaps using R

Re: [GENERAL] Select Column Auditing/Logging

2009-07-22 Thread Jeff Davis
On Wed, 2009-07-22 at 12:04 -0700, Jeremy Brown wrote: > It seems that PostgreSQL can audit INSERT, UPDATE, DELETE, and > TRUNCATE through the use of triggers. But SELECT triggers are > unsupported (it does suggest perhaps using RULES). One thing you can do is use a set-returning function that, a

Re: [GENERAL] Select Column Auditing/Logging

2009-07-22 Thread Jeff Davis
On Wed, 2009-07-22 at 14:41 -0700, Jeff Davis wrote: > On Wed, 2009-07-22 at 12:04 -0700, Jeremy Brown wrote: > > It seems that PostgreSQL can audit INSERT, UPDATE, DELETE, and > > TRUNCATE through the use of triggers. But SELECT triggers are > > unsupported (it does suggest perhaps using RULES).