public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Tom Lane <[email protected]>
Cc: gabrielle <[email protected]>
Cc: [email protected]
Subject: Re: [PATCH] log_statement docs
Date: Thu, 25 Feb 2010 14:20:41 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
Tom Lane wrote:
> Bruce Momjian <[email protected]> writes:
> > gabrielle wrote:
> >> On Wed, Feb 24, 2010 at 7:14 PM, Tom Lane <[email protected]> wrote:
> >>> Shouldn't it just say "all means all", if we think that needs to be
> >>> explained?
> >>
> >> I think it should say something about the "all" option. I read &
> >> re-read that section trying to figure out what the difference between
> >> "mod" and "all" was, and finally asked on the irc channel. As it
> >> stands, it essentially says "there are three options to this command,
> >> but we're only going to tell you about two of them." :)
>
> > Well, if you take a look at utility.c:GetCommandLogLevel() you will see
> > that ALL includes a lot more commands than just SELECT.
>
> Yeah. My objection was not to documenting ALL, it was to documenting it
> with exactly that sentence, which seems both needlessly complicated and
> subject to errors of omission.
I have applied the following patch with adds "off" and "all statements"
identifiers. This is probaby the right level of detail for this.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +
Attachments:
[text/x-diff] /rtmp/diff (1.3K, 2-%2Frtmp%2Fdiff)
download | inline diff:
Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.253
diff -c -c -r1.253 config.sgml
*** doc/src/sgml/config.sgml 25 Feb 2010 13:26:15 -0000 1.253
--- doc/src/sgml/config.sgml 25 Feb 2010 19:19:14 -0000
***************
*** 3392,3399 ****
<listitem>
<para>
Controls which SQL statements are logged. Valid values are
! <literal>none</>, <literal>ddl</>, <literal>mod</>, and
! <literal>all</>. <literal>ddl</> logs all data definition
statements, such as <command>CREATE</>, <command>ALTER</>, and
<command>DROP</> statements. <literal>mod</> logs all
<literal>ddl</> statements, plus data-modifying statements
--- 3392,3399 ----
<listitem>
<para>
Controls which SQL statements are logged. Valid values are
! <literal>none</> (off), <literal>ddl</>, <literal>mod</>, and
! <literal>all</> (all statements). <literal>ddl</> logs all data definition
statements, such as <command>CREATE</>, <command>ALTER</>, and
<command>DROP</> statements. <literal>mod</> logs all
<literal>ddl</> statements, plus data-modifying statements
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [PATCH] log_statement docs
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox