Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
That was understood. What i meant is that the only time i see anything
*related to* the prepared statement i think should be there is when the
EXECUTE fails for some reason because the context of the error is
logged. That particular EXECUTE wa
brian <[EMAIL PROTECTED]> writes:
> That was understood. What i meant is that the only time i see anything
> *related to* the prepared statement i think should be there is when the
> EXECUTE fails for some reason because the context of the error is
> logged. That particular EXECUTE was preceeded
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
The only hint of a prepared statement being logged is when there's an
error. eg:
<2007-09-05 17:35:22 EDT>ERROR: duplicate key violates unique
constraint "auth_member_id_key"
<2007-09-05 17:35:22 EDT>STATEMENT: EXECUTE
mdb2_statement_pgsq
brian <[EMAIL PROTECTED]> writes:
> The only hint of a prepared statement being logged is when there's an
> error. eg:
> <2007-09-05 17:35:22 EDT>ERROR: duplicate key violates unique
> constraint "auth_member_id_key"
> <2007-09-05 17:35:22 EDT>STATEMENT: EXECUTE
> mdb2_statement_pgsqla0e8d351
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
But that should mean that my prepared statement that contains an INSERT
should be logged, yes? (8.1 issues notwithstanding)
I ask because i've set log_statement to 'mod' but am not seeing any
of my prepared statements in the log. INSERT, UPDATE
brian <[EMAIL PROTECTED]> writes:
> But that should mean that my prepared statement that contains an INSERT
> should be logged, yes? (8.1 issues notwithstanding)
> 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 friend
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
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 a
brian <[EMAIL PROTECTED]> writes:
> 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 appropriat
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 ex
