Re: psql 15beta1 does not print notices on the console until transaction completes - Mailing list pgsql-bugs

[ 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 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