Thanks Craig fro you reply,
7.2 does have statement logging from within functions.
How? these are the settings we use in our production environments. (7.2)
debug_level = 2
log_connections = off
log_pid = on
log_timestamp = on
syslog = 0
Why, we use logging fro production problem resolution.
We have been using Postgres for 8 years, hundreds of functions have been written, we have become reliant on logging for production support.
Thanks
Andrew Bartley
PS on this note, how do we log PIDS? This is another "need to have" for our production systems. We log user activity and trace DB activity through the PIDS.
2009/8/17 Craig Ringer
<craig@postnewspapers.com.au>On 17/08/2009 10:32 AM, Andrew Bartley wrote:
Hi All,
We have recently upgraded postgres from 7.2 to 8.3.
I am struggling with the logging options when it comes to functions.
How do log statements from within a Function?
You don't, generally.
Perhaps we should back up a step or two. Did you have statement logging within PL/PgSQL functions in 7.2? If so, how? Why do you need statement logging within functions? What are you trying to achieve with it?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general