From: | Alastair McKinley <a(dot)mckinley(at)analyticsengines(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | psql 15beta1 does not print notices on the console until transaction completes |
Date: | 2022-05-29 20:11:22 |
Message-ID: | PAXPR02MB760039506C87A2083AD85575E3DA9@PAXPR02MB7600.eurprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
Hi all,
I notice this change in behaviour with psql in 15beta1 when testing an existing codebase.
I didn't see any mention of this change in the release notes and it surprised me.
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.
Is there a way to change psql behaviour to display notices immediately as in versions < 15?
Best regards,
Alastair
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-05-29 20:27:05 | Re: psql 15beta1 does not print notices on the console until transaction completes |
Previous Message | Daniel Farkaš | 2022-05-29 18:58:29 | Re: BUG #17502: View based on window functions returns wrong results when queried |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-05-29 20:27:05 | Re: psql 15beta1 does not print notices on the console until transaction completes |
Previous Message | Alastair McKinley | 2022-05-29 19:26:20 | Re: Function definition regression in 15beta1 when specific parameter name (string) is used |