Postgres Pro
Downloads
Home   >   mailing lists

Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block
Date
Msg-id CA+TgmoZMLA6G3ZknhDuC02evgU6Dc5GGb+-7YaonR-Qc=TcUXA@mail.gmail.com
Whole thread Raw
In response to Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block  (Quan Zongliang <quanzongliang@yeah.net>)
Responses Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block
List pgsql-hackers
Tree view 
On Thu, May 16, 2024 at 6:01 AM Quan Zongliang <quanzongliang@yeah.net> wrote:
> I thought about writing statement log when xid assigned. But it's seemed
> too complicated.
> I'm inclined to keep it for a while. Until we find a good way or give
> up. It's a reasonable request, after all.

I don't think it's reasonable at all. We can't log the XID before it's
assigned, and we can't log the statement after the XID is assigned
without completely changing how the parameter works.

--
Robert Haas
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: CREATE DATABASE with filesystem cloning
Next
From: Robert Haas
Date:
Subject: Re: CREATE DATABASE with filesystem cloning