RAISE NOTICE doesn't put anything into console

[Gchapliy]

Describe the bug
When I try to debug my routine I would like to see results of every RAISE NOTICE call but there are nothing happens. I try to do the same but in the pgAdmin and then I can see all messages.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Intellij Idea'
2. Click on 'Database panel on the frame right side'
3. Expand my database routines
4. Scroll down to needed routine
5. Click on it and run 'debug routine'
6. When breakpoint with raise notice passed no results in console

Expected behavior
Message should appear with data I put there as It does in pgAdmin

Screenshots

Desktop (please complete the following information):

• Windows
• Chrome
• Version 117.0.5938.92 (Official Build) (64-bit)
• IntelliJ IDEA 2022.3.1 (Ultimate Edition) Build #IU-223.8214.52, built on December 20, 2022

[ng-galien]

Hello,
There is a misunderstanding here about RAISE NOTICE.
It outputs only in the builtin Intellij query output.
Second, and probably by design, the NOTICE output is available when the query completes.
The only way to track values with the debugger is to put these in a variable.
Also, you can add these trace to a text array.

[Gchapliy]

It's great suggestion. Thanks a lot.