brian <brian@xxxxxxxxxxxxxxxx> 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