log_statement and PREPARE - Mailing list pgsql-general

From brian
Subject log_statement and PREPARE
Date
Msg-id 46E08582.2030409@zijn-digital.com
Whole thread Raw
Responses Re: log_statement and PREPARE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
The docs (8.1) say the following about log_statement:

-- snip --
... mod logs all ddl statements, plus INSERT, UPDATE, DELETE, TRUNCATE,
and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if
their contained command is of an appropriate type.
-- snip --

Can someone please expain the meaning of, "if their contained command is
of an appropriate type"? I take it to mean that the prepared statement
will be logged if the it contains an INSERT (if 'mod' was chosen, of
course).

I ask because i've set log_statement to 'mod' but am not seeing any of
my prepared statements in the log. INSERT, UPDATE, and friends i do see.

FWIW, the app is PHP using MDB2. But checking its source doesn't give me
any reason to believe the issue lies there. Shouldn't i see these PREPAREs?

brian

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Next
From: Tom Lane
Date:
Subject: Re: Do AGGREGATES consistently use sort order?