From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alastair McKinley <a.mckinley@analyticsengines.com>
cc: pgsql-bugs@lists.postgresql.org,
        Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        Fabien COELHO <coelho@cri.ensmp.fr>
Subject: Re: psql 15beta1 does not print notices on the console until
 transaction completes
In-reply-to: 
 <PAXPR02MB760039506C87A2083AD85575E3DA9@PAXPR02MB7600.eurprd02.prod.outlook.com>
References: 
 <PAXPR02MB760039506C87A2083AD85575E3DA9@PAXPR02MB7600.eurprd02.prod.outlook.com>
Comments: In-reply-to Alastair McKinley <a.mckinley@analyticsengines.com>
	message dated "Sun, 29 May 2022 20:11:22 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3662993.1653856025.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 29 May 2022 16:27:05 -0400
Message-ID: <3662994.1653856025@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3662994.1653856025%40sss.pgh.pa.us>
Precedence: bulk

[ redirecting to -bugs ]

Alastair McKinley <a.mckinley@analyticsengines.com> writes:
> Using this test function:

>     create or replace function test_notice() returns void as =

>     $$ =

>     begin =

>         raise notice 'hello'; =

>         perform pg_sleep(10); =

>     end; $$ language plpgsql;

> In psql 15beta1, the "hello" message only appears on the console when th=
e transaction completes.
> in psql 14.3, it appears immediately as I would have expected.

A quick cross-check confirms that this is a psql, not server,
behavior change.  I didn't bisect, but I'm betting this is a
side-effect of 7844c9918 (Show all query results by default).

I agree it's pretty undesirable, so I'm adding it as an open issue.

			regards, tom lane