From: | brian <brian(at)zijn-digital(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | log_statement and PREPARE |
Date: | 2007-09-06 22:56:02 |
Message-ID: | 46E08582.2030409@zijn-digital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2007-09-06 22:58:44 | Re: an other provokative question?? |
Previous Message | Tom Lane | 2007-09-06 22:52:56 | Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS) |