public inbox for [email protected]
help / color / mirror / Atom feedFrom: Álvaro Herrera <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: [email protected]
Subject: Re: Notices not printed by PQtrace
Date: Tue, 5 Aug 2025 15:17:52 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFCRh-8nRjXnjJTJ+SKaEF_5cwh5mi0LkAbNy4qB3uNYEQr_Xw@mail.gmail.com>
On 2025-Aug-05, Dominique Devienne wrote:
> Hi. I'm using PQtrace for client-side tracing with PQtrace,
> which I thought was showing protocol messages in details.
>
> But turns out that RAISE notices from PL/pgSQL are not there.
Hmm, don't they show up as NOTICE messages? I think they should.
Maybe you could set a notice receiver and have it print to the same
file? I think I had to do that at some point.
> And to think about it, I wonder whether NOTIFY messages are there too.
Please test it and let's us know :-)
> Are these oversights?
Yeah, probably. As far as I am concerned, the current PQtrace() code
was mostly written to allow us to develop libpq pipeline mode. (I don't
know what had Aya Iwata in mind when she wrote it.) For that, neither
NOTICE nor NOTIFY were very interesting, so I didn't stop to think about
them.
> Any chance this could be enhanced, via new opt-in PQsetTraceFlags flags?
> Ideally I've like to see everything.
Yeah, I think that makes sense. Feel free to propose a patch.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"In Europe they call me Niklaus Wirth; in the US they call me Nickel's worth.
That's because in Europe they call me by name, and in the US by value!"
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Notices not printed by PQtrace
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox