Re: log_statement variable does not admit all value

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Jose Carlos Martinez Llario <jomarlla(at)cgf(dot)upv(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: log_statement variable does not admit all value
Date: 2012-01-21 21:18:46
Message-ID: CAFjNrYtkuPSa87jbsc75aaTSePugVjU2DB3j-WD2SzeWXOTGTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 21 January 2012 22:11, Jose Carlos Martinez Llario
<jomarlla(at)cgf(dot)upv(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-01-22 01:39:41 Re: Database takes up MUCH more disk space than it should
Previous Message Adrian Klaver 2012-01-21 21:17:22 Re: log_statement variable does not admit all value