Re: Function Logging - Mailing list pgsql-general

From Craig Ringer
Subject Re: Function Logging
Date
Msg-id 4A88E58A.2000503@postnewspapers.com.au
Whole thread Raw
In response to Function Logging  ("Andrew Bartley" <abartley@aimstats.com>)
Responses Re: Function Logging  (Andrew Bartley <ambartley@gmail.com>)
List pgsql-general
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 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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: plpgsql function to validate e-mail
Next
From: Andrew Bartley
Date:
Subject: Re: Function Logging