Re: [GENERAL] Function Logging

2009-08-19 Thread Adrian Klaver
On Tuesday 18 August 2009 8:08:39 pm Craig Ringer wrote: > On 18/08/2009 9:26 PM, Adrian Klaver wrote: > > On Monday 17 August 2009 8:50:09 pm Andrew Bartley wrote: > >> So the information i have thus far is that, I am not easily able to log > >> the statements from a function. > >> > >> Does anyon

Re: [GENERAL] Function Logging

2009-08-18 Thread Craig Ringer
On 18/08/2009 9:26 PM, Adrian Klaver wrote: On Monday 17 August 2009 8:50:09 pm Andrew Bartley wrote: So the information i have thus far is that, I am not easily able to log the statements from a function. Does anyone know why it was removed... that is it 7.2 logged this information. Thanks Ag

Re: [GENERAL] Function Logging

2009-08-18 Thread Adrian Klaver
On Monday 17 August 2009 8:50:09 pm Andrew Bartley wrote: > So the information i have thus far is that, I am not easily able to log the > statements from a function. > > Does anyone know why it was removed... that is it 7.2 logged this > information. > > Thanks Again > > Andrew Bartley > You are g

Re: [GENERAL] Function Logging

2009-08-17 Thread Andrew Bartley
So the information i have thus far is that, I am not easily able to log the statements from a function. Does anyone know why it was removed... that is it 7.2 logged this information. Thanks Again Andrew Bartley 2009/8/18 Andrew Bartley > Thanks Alvaro, > > I still need to be able to log state

Re: [GENERAL] Function Logging

2009-08-17 Thread Andrew Bartley
Thanks Alvaro, I still need to be able to log statements from within functions... Can you help with that? 2009/8/18 Alvaro Herrera > Andrew Bartley escribió: > > > PS on this note, how do we log PIDS? This is another "need to have" for > our > > production systems. We log user activity and t

Re: [GENERAL] Function Logging

2009-08-17 Thread Alvaro Herrera
Andrew Bartley escribió: > 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. See log_line_prefix. You can use something like '%p ' (note the space at the end), or stuff like the sessi

Re: [GENERAL] Function Logging

2009-08-16 Thread Andrew Bartley
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. W

Re: [GENERAL] Function Logging

2009-08-16 Thread Craig Ringer
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? A PL/PgSQL function? You don't, generally. Perhaps we should back up

[GENERAL] Function Logging

2009-08-16 Thread Andrew Bartley
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? Thanks Andrew Bartley

[GENERAL] Function Logging

2009-08-16 Thread Andrew Bartley
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? Thanks Andrew Bartley