Postgres Pro
Downloads
Home   >   mailing lists

Re: log_statement variable does not admit all value - Mailing list pgsql-general

From Szymon Guz
Subject Re: log_statement variable does not admit all value
Date
Msg-id CAFjNrYtkuPSa87jbsc75aaTSePugVjU2DB3j-WD2SzeWXOTGTQ@mail.gmail.com
Whole thread Raw
In response to log_statement variable does not admit all value  (Jose Carlos Martinez Llario <jomarlla@cgf.upv.es>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: log_statement variable does not admit all value
Next
From: Scott Marlowe
Date:
Subject: Re: Database takes up MUCH more disk space than it should