Re: Logging transaction IDs for DDL.

2018-06-14 Thread Magnus Hagander
On Thu, Jun 14, 2018 at 12:34 AM, Vik Fearing wrote: > I just noticed a problem with log_statement = 'ddl' and log_line_prefix > containing '%x'. If the statement is the first in the transaction, it > will be logged before it is executed, and more importantly, before a > transaction ID is assign

Re: Logging transaction IDs for DDL.

2018-06-13 Thread Andres Freund
Hi, On 2018-06-14 00:34:54 +0200, Vik Fearing wrote: > I just noticed a problem with log_statement = 'ddl' and log_line_prefix > containing '%x'. If the statement is the first in the transaction, it > will be logged before it is executed, and more importantly, before a > transaction ID is assigne

Logging transaction IDs for DDL.

2018-06-13 Thread Vik Fearing
I just noticed a problem with log_statement = 'ddl' and log_line_prefix containing '%x'. If the statement is the first in the transaction, it will be logged before it is executed, and more importantly, before a transaction ID is assigned. That means that %x will be 0. If the administrator has co