Обсуждение: log_statement variable does not admit all value

Поиск
Список
Период
Сортировка

log_statement variable does not admit all value

От
Jose Carlos Martinez Llario
Дата:
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

От
Adrian Klaver
Дата:
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

От
Szymon Guz
Дата:


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