Re: changing log_min_duration_statement - Mailing list pgsql-general

From Ben Chobot
Subject Re: changing log_min_duration_statement
Date
Msg-id 7E01B910-CEC8-43B1-9015-B4D676E2B596@silentmedia.com
Whole thread Raw
In response to Re: changing log_min_duration_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: changing log_min_duration_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Jan 19, 2010, at 2:32 PM, Tom Lane wrote:

> You might try looking at the pg_settings row for the variable to see
> what it says the source is.


That's interesting:

foo# select source from pg_settings where name='log_min_duration_statement';
  source
----------
 database

foo# alter database foo reset log_min_duration_statement;
ALTER DATABASE

foo# select source from pg_settings where name='log_min_duration_statement';
  source
----------
 database


Shouldn't the source change to "config file" after the reset?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: changing log_min_duration_statement
Next
From: Tom Lane
Date:
Subject: Re: changing log_min_duration_statement