Bug 257457

Created attachment 158044 [details]
Patch

When calling SQL stored procedures having some diagnostic messages generated inside - they are NOT displayed in NetBeans' output window.

With execution of the following SQL code (PostgerSQL) ...

        CREATE OR REPLACE FUNCTION dummy()
            RETURNS timestamp LANGUAGE plpgsql AS $$
        DECLARE
        BEGIN
            raise notice 'dummy as (%)', now();
            return now();
        END $$;

        select dummy();

... I expect following to be displayed in output:

        NOTICE: dummy as (2016-01-07 14:37:44.845092+03)
        Executed successfully in 0 s.
        Line XX, column YY

I've created a patch to fix this, it also includes changes to fix issue https://netbeans.org/bugzilla/show_bug.cgi?id=257363 (otherwise $$-quotes will not be recognized)