Re: some log statements ignored

Bruce Momjian wrote:
> brian wrote:
>
>>I changed my postgresql.conf to have:
>>
>>log_statement = mod
>>
>>It appears to be working, though not logging *all* INSERTs. For
>>instance, I have a PHP class that inserts into two tables in a
>>transaction. The log shows the first, but not the second. Has anyone
>>seen this behaviour?
>>
>>
>>test=# show log_statement;
>>  log_statement
>>---------------
>>  mod
>>(1 row)
>
>
> I have no idea why that would happen.  If you do 'all' do you see all of
> them?
>

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 ...

(this is using the PEAR MDB2 package)

So, log_statement= 'mod' won't log a "PREPARE ... AS INSERT", i guess.

b