Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 857476336B3
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon,  6 Apr 2009 16:54:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 46259-01 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon,  6 Apr 2009 16:54:40 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from momjian.us (momjian.us [70.90.9.53])
	by mail.postgresql.org (Postfix) with ESMTP id D3AC36336AD
	for <pgsql-docs@postgresql.org>; Mon,  6 Apr 2009 16:54:43 -0300 (ADT)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id
 n36JshH07215;
	Mon, 6 Apr 2009 15:54:43 -0400 (EDT)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200904061954.n36JshH07215@momjian.us>
Subject: Re: log_min_duration_statement units
In-Reply-To: <11288.1239047341@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Date: Mon, 6 Apr 2009 15:54:43 -0400 (EDT)
CC: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL124 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.057 tagged_above=0 required=5 tests=AWL=0.057
X-Spam-Level: 
X-Archive-Number: 200904/10
X-Sequence-Number: 5098

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > ! #log_min_duration_statement = -1	# -1 is disabled, 0 logs all statements
>   
> > ! #log_min_duration_statement = -1ms	# -1 is disabled, 0 logs all statements
> 
> This is not sensible -- there are no units for the "-1" setting.  I
> seem to recall that it won't even work; did you test uncommenting that?

I tested it uncommented and manually and it worked fine:

	test=> set log_min_duration_statement = '-1ms';
	SET
	test=> show log_min_duration_statement;
	 log_min_duration_statement
	----------------------------
	 -1
	(1 row)

It seems illogical to document it this way but a non-EDB trainer emailed
me saying students are getting confused about the default units, and I
can see how they would get confused.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +