Re: some log statements ignored

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: brian <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: some log statements ignored
Date: 2006-10-13 17:16:36
Message-ID: 2941.1160759796@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

brian <brian(at)zijn-digital(dot)com> writes:
> Sorry--i hadn't had time to run a test. Setting it to 'all' works fine,
> and i think i see the problem: the second INSERT is in a prepared
> statement, so it's not being logged.

> PREPARE mdb2_statement_pgsql00fb05c2c509aa2608b68bf2b87693a2 AS INSERT
> INTO ...

I'm betting that's really a Parse protocol message, not a PREPARE
statement as such (the 8.1 logging code misguidedly tries to obscure the
difference). The logging of the subsequent Bind/Execute messages is
really weak in existing releases :-(. We've fixed it up for 8.2 though.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-13 17:22:22 Re: UTF-8
Previous Message Martijn van Oosterhout 2006-10-13 17:03:41 Re: more anti-postgresql FUD