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

From Adrian Klaver
Subject Re: psql 15beta1 does not print notices on the console until transaction completes
Date
Msg-id b255aee9-ff01-b59b-f6f6-8becb0d1a0d0@aklaver.com
Whole thread Raw
In response to psql 15beta1 does not print notices on the console until transaction completes  (Alastair McKinley <a.mckinley@analyticsengines.com>)
Responses Re: psql 15beta1 does not print notices on the console until transaction completes
Re: psql 15beta1 does not print notices on the console until transaction completes
List pgsql-general
On 5/29/22 13:11, Alastair McKinley wrote:
> 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.

I am not seeing that.

Can you provide more information about how you are running test_notice()?

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Alastair McKinley
Date:
Subject: psql 15beta1 does not print notices on the console until transaction completes
Next
From: Shaheed Haque
Date:
Subject: Is it possible to index "deep" into a JSONB column?