Thread: log_statement variable does not admit all value

log_statement variable does not admit all value

From

Jose Carlos Martinez Llario

Date:

21 January 2012, 20:11:55

Hi List,

This variable admit according to docs: mod, ddl, all values. the all
value is not accepted.
I have postgres 9.1.

s1=# set log_statement = all;
ERROR:  syntax error at or near "all"
LINE 1: set log_statement = all;


cheers,
Jose

Re: log_statement variable does not admit all value

From

Adrian Klaver

Date:

21 January 2012, 20:17:42

On Saturday, January 21, 2012 1:11:32 pm Jose Carlos Martinez Llario wrote:
> Hi List,
>
> This variable admit according to docs: mod, ddl, all values. the all
> value is not accepted.
> I have postgres 9.1.
>
> s1=# set log_statement = all;

set log_statement = 'all';

> ERROR:  syntax error at or near "all"
> LINE 1: set log_statement = all;
>
>
> cheers,
> Jose

--
Adrian Klaver
adrian.klaver@gmail.com

Re: log_statement variable does not admit all value

From

Szymon Guz

Date:

21 January 2012, 20:19:02

On 21 January 2012 22:11, Jose Carlos Martinez Llario <jomarlla@cgf.upv.es> wrote:

Hi List,

This variable admit according to docs: mod, ddl, all values. the all value is not accepted.
I have postgres 9.1.

s1=# set log_statement = all;
ERROR: syntax error at or near "all"
LINE 1: set log_statement = all;

cheers,
Jose

Hi,

just try this:

set log_statement = 'all';

regards
Szymon