Re: Help with tracking!

On Tue, Apr 20, 2010 at 8:31 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:
>> On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
>>> Wouldn't this work:
>>>
>>> alter user smarlowe set log_statement = 'all';
>>
>> IIRC it only works inside the given session (so it needs to be run each
>> time a query will be executed)
>
> Not true:
>
> psql
> show log_statement;
>  log_statement
> ---------------
>  none
> alter user smarlowe set log_statement = 'all';
> show log_statement;
>  log_statement
> ---------------
>  all
> \q
> psql
> show log_statement;
>  log_statement
> ---------------
>  all

Note however that other sessions won't see the change. Only
connections that come after the change will see it.