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

[ redirecting to -bugs ]

Alastair McKinley <a(dot)mckinley(at)analyticsengines(dot)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 the 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