Re: [ADMIN] access log for 1 table

2011-09-13 Thread Guillaume Lelarge
On Mon, 2011-09-12 at 13:42 -0500, Peter Koczan wrote: > Is there any way to set an access log for a specific table? > > What I'd like to do is have a record of all access for one table. It > would be nice to do this by raising a notice and having it show up in > syslog. I could use triggers, but

[ADMIN] access log for 1 table

2011-09-12 Thread Peter Koczan
Is there any way to set an access log for a specific table? What I'd like to do is have a record of all access for one table. It would be nice to do this by raising a notice and having it show up in syslog. I could use triggers, but I would need to log for SELECT queries as well. Rules look like l