On Thu, Feb 22, 2007 at 12:25:42PM +0200, Sabin Coanda wrote:
> I'd like to check that my log_line_prefix is set to '%t'.
> I suppose I can check it with the following statement:
> SELECT current_setting( 'log_line_prefix' )
> WHERE current_setting( 'log_line_prefix' ) != '%t'
>
> But it returns every time a row, with '%t', even when log_line_prefix is set
> to '%t'.
> What's wrong ?
Works here. Might log_line_prefix have leading or trailing spaces?
What does the following return?
SELECT '<' || current_setting('log_line_prefix') || '>',
length(current_setting('log_line_prefix'));
--
Michael Fuhr