log_statement variable does not admit all value

Started by Jose Carlos Martinez Llarioover 14 years ago3 messagesgeneral
Jump to latest

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

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Jose Carlos Martinez Llario (#1)
Re: log_statement variable does not admit all value

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

#3Szymon Guz
mabewlun@gmail.com
In reply to: Jose Carlos Martinez Llario (#1)
Re: log_statement variable does not admit all value

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