I'm using PgAdmin to create multiple pgsql functions. I'm beginner on this environment. I'm using 'raise notice' to help me for debugging phase.
I have two functions with 'raise notice' statement. The first function calls the second function.
I can show the 'raise notice' statement for the first function. I can't show the 'raise notice' statement for the second function. In place, the console show blank lines for each 'raise notice' that should be shown.
Function 1 - Example :
raise notice 'Function 1 executing'; -- This raise notice works
PERFORM public.function_2();
Function 2 - Example :
raise notice 'Function 2 is now running'; -- This raise notice doesn't work
Is it possible to do what I want?