[GENERAL] pg_lesslog - status?

2012-10-28 Thread Karl Denninger
Does anyone know where this stands? I used this a while back in the 8.x days but had a serious bug problem with it -- which was later fixed. The latest checks I can find say it was updated for 9.0, but that leaves open the question as to whether it functions correctly with the current release.

[GENERAL] table logging

2012-10-28 Thread Jeff Janes
I am looking for some very simple table logging. I am not trying to do auditing in a hostile environment, just simple logging. I found two candidates, tablelog from pgfoundry, and http://wiki.postgresql.org/wiki/Audit_trigger_91plus The first has the advantage of being simple, but hasn't been

Re: [GENERAL] table logging

2012-10-28 Thread Julian
On 29/10/12 06:25, Jeff Janes wrote: I am looking for some very simple table logging. I am not trying to do auditing in a hostile environment, just simple logging. I found two candidates, tablelog from pgfoundry, and http://wiki.postgresql.org/wiki/Audit_trigger_91plus The first has the

Re: [GENERAL] pg_lesslog - status?

2012-10-28 Thread Michael Paquier
On Mon, Oct 29, 2012 at 4:08 AM, Karl Denninger k...@denninger.net wrote: Does anyone know where this stands? pg_lesslog has been created initially by Koichi Suzuki at NTT, and as far as I know, nobody is maintaining this project there. I used this a while back in the 8.x days but had a

[GENERAL] SPI_prepare's parameter

2012-10-28 Thread 高健
I am new to PostgreSQL's SPI(Server Programming Interface). I can understand PostgreSQL's exampel of using SPI. But I am not sure about SPI_prepare's parameter. void * SPI_prepare(const char * command, int nargs, Oid * argtypes) Can somebody kindly give an example of using SPI_prepare ?

[GENERAL] How to print application_name in log_line_prefix (using %a)?

2012-10-28 Thread Tianyin Xu
Hi, guys, Could anyone tell me how to specify the application_name as the log_line_prefix? According to the manual at http://www.postgresql.org/docs/9.2/static/runtime-config-logging.html#GUC-APPLICATION-NAME : application_name (string) The application_name can be any string of less than

[GENERAL] How to print application_name in log_line_prefix (using %a)?

2012-10-28 Thread Tianyin Xu
Hi, guys, Could anyone tell me how to specify the application_name as the log_line_prefix? According to the manual at http://www.postgresql.org/docs/9.2/static/runtime-config-logging.html#GUC-APPLICATION-NAME : application_name (string) The application_name can be any string of less than