postgres.git / summary / log / commit / refs

commit    0549ba82e32410892ef0d644212436551974aa2b
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Oct 19 22:55:25 2006 +0000
First released in: 8.2.0

    Clarify note about interaction of log_statement logging with errors.
    Remove obsolete note about logging of statements generated by plpgsql
    function execution ... that doesn't happen anymore.


 doc/src/sgml/config.sgml | 22 +++++++++-------------
 1 file changed, 9 insertions(+), 13 deletions(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 549ca755d70..ea6c4efb2aa 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.90 2006/10/07 19:25:28 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.91 2006/10/19 22:55:25 tgl Exp $ -->
 
 <chapter Id="runtime-config">
   <title>Server Configuration</title>
@@ -2891,18 +2891,14 @@ SELECT * FROM parent WHERE key = 2400;
 
        <note>
         <para>
-         Statements that generate syntax errors are not logged.  Set
-         <varname>log_min_error_statement</> to <literal>error</> to
-         log such statements.      
-        </para>
-
-        <para>
-         When a function is defined in the
-         <application>PL/pgSQL</application>server-side language, any queries
-         executed by the function will only be logged the first time that the
-         function is invoked in a particular session. This is because
-         <application>PL/pgSQL</application> keeps a cache of the
-         query plans produced for the SQL statements in the function.
+         Statements that contain simple syntax errors are not logged
+         even by the <varname>log_statement</> = <literal>all</> setting,
+         because the log message is emitted only after basic parsing has
+         been done to determine the statement type.  In the case of extended
+         query protocol, this setting likewise does not log statements that
+         fail before the Execute phase (i.e., during parse analysis or
+         planning).  Set <varname>log_min_error_statement</> to
+         <literal>error</> to log such statements.      
         </para>
        </note>
       </listitem>


[parent: 1b84441a4912]