Re: psql 15beta1 does not print notices on the console until transaction completes

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Alastair McKinley <a(dot)mckinley(at)analyticsengines(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: psql 15beta1 does not print notices on the console until transaction completes
Date: 2022-05-29 21:14:02
Message-ID: 6d14b1d1-fb8b-87d3-bdf8-d3c93c8bbb7b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On 5/29/22 13:59, Alastair McKinley wrote:
> >
> > From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> > Sent: 29 May 2022 21:47To: Alastair McKinley

> Hi Adrian,
>
> I am running the function "select test_notice();" from the psql console
> with psql/server versions 15beta1.
>
> In psql 15beta1, the notice appears only after the function
> returns/transaction completes.
>
> If I execute the same function from psql 14.3 and server 15beta1, the
> notice appears on the psql console immediately as expected, before the
> pg_sleep() completes.
>
> It's reproducible for me, I just double checked it.

Yeah, I see the same thing after using the new psql.

>
> I think Tom was able to reproduce this by the sounds of his response?

I have not received that post yet. I do see it in the archives. I had
already tried:

\set SHOW_ALL_RESULTS off

which is supposed to restore to previous behavior, but it did not lead
to the 14.3 result.

>
> Best regards,
>
> Alastair
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-05-29 22:03:38 Re: psql 15beta1 does not print notices on the console until transaction completes
Previous Message Heikki Linnakangas 2022-05-29 21:09:38 Re: BUG #17501: COPY is failing with "ERROR: invalid byte sequence for encoding "UTF8": 0xe5"

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-05-29 22:03:38 Re: psql 15beta1 does not print notices on the console until transaction completes
Previous Message Adrian Klaver 2022-05-29 20:59:53 Re: psql 15beta1 does not print notices on the console until transaction completes