Postgres Pro
Downloads
Home   >   mailing lists

How compare current_setting(..) ? - Mailing list pgsql-sql

From Sabin Coanda
Subject How compare current_setting(..) ?
Date
Msg-id erjr2t$sdn$1@news.hub.org
Whole thread Raw
Responses Re: How compare current_setting(..) ?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
Hi there,

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 ?

TIA,
Sabin

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Problems with temp table and PL
Next
From: Michael Fuhr
Date:
Subject: Re: How compare current_setting(..) ?