From 9fd842c4b20d55746d34a96bc6baec7d2242c2cf Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Mon, 2 Sep 2002 05:42:54 +0000
Subject: Add GUC variable to print original query to the server logs when
 there is an error, warning, etc.

Gavin Sherry
---
 doc/src/sgml/runtime.sgml | 29 +++++++++++++++++++++++++----
 1 file changed, 25 insertions(+), 4 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml
index 42677b20e14..d43461e61b7 100644
--- a/doc/src/sgml/runtime.sgml
+++ b/doc/src/sgml/runtime.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.132 2002/09/01 23:26:06 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.133 2002/09/02 05:42:54 momjian Exp $
 -->
 
 <Chapter Id="runtime">
@@ -942,7 +942,6 @@ env PGOPTIONS='-c geqo=off' psql
        </para>
       </listitem>
      </varlistentry>
-
      <varlistentry>
       <term><varname>EXPLAIN_PRETTY_PRINT</varname> (<type>boolean</type>)</term>
       <listitem>
@@ -978,6 +977,28 @@ env PGOPTIONS='-c geqo=off' psql
       </listitem>
      </varlistentry>
 
+     <varlistentry>
+      <term><varname>LOG_MIN_ERROR_STATEMENT</varname> (<type>string</type>)</term>
+      <listitem>
+       <para>
+        This controls which log messages are accompanied by the original
+        query which generated the message. All queries matching the setting
+        or which are of a higher severity than the setting are logged. The
+        default is <literal>ERROR</literal>. Valid values are
+        <literal>DEBUG5</literal>, <literal>DEBUG4</literal>, 
+        <literal>DEBUG3</literal>, <literal>DEBUG2</literal>, 
+        <literal>DEBUG1</literal>, <literal>INFO</literal>,
+        <literal>NOTICE</literal>, <literal>WARNING</literal>
+        and <literal>ERROR</literal>.
+       </para>
+       <para>
+        It is recommended you enable <literal>LOG_PID</literal> as well
+        so you can more easily match the error statement with the error
+        message.
+       </para>
+      </listitem>
+     </varlistentry>
+
      <varlistentry>
       <term><varname>LOG_PID</varname> (<type>boolean</type>)</term>
       <listitem>
@@ -1005,8 +1026,8 @@ env PGOPTIONS='-c geqo=off' psql
       <listitem>
        <para>
         Prints the duration of every completed query.  To use this option, 
-        enable LOG_STATEMENT and LOG_PID so you can link the original query
-        to the duration using the process id.
+        enable <literal>LOG_STATEMENT</> and <literal>LOG_PID</> so you 
+        can link the original query to the duration using the process id.
        </para>
       </listitem>
      </varlistentry>
-- 
cgit v1.2.3