When running anonymous code blocks or when using the RAISE [1] statement for PL/pgSQL, ADS waits for the entire function / script to process _before_ printing / displaying RAISE statements to the Messages Results tab/window. Other products like DBeaver, NaviCat, DataGrid print RAISE(s) as they executed in the function / script logic.
When running a script that may take a long time, I have no indication of what's going on (other than the spinning wheel in the Query Analyzer tab) and must wait for the conclusion of the script. If I had feedback from ADS in the form of my "debug" RAISE NOTICE statements, I could abort my script, fix it and re-run it.
https://www.postgresql.org/docs/9.6/plpgsql-errors-and-messages.html
Issue #15673 |
New |
Completion |
No due date |
No fixed build |
No time estimate |