Horton
Menu

Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Quan Zongliang <quanzongliang@yeah.net>
Cc: jian he <jian.universality@gmail.com>, "Andrey M. Borodin" <x4mmm@yandex-team.ru>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2024-05-16T12:37:43Z
Lists: pgsql-hackers 
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