Toad World® Forums

Cannot Execute Function Blocks


#1

I have the following function block:

DO $$
<<my_block>>
BEGIN
RAISE NOTICE ‘Hello, World!’;
END my_block$$;

This is valid syntax in pgAdmin4 and DataGrip, but I cannot execute this in Toad Edge. I get the following errors:

  • Syntax error, found: ‘<<’ at line 2, column 1. ERROR: line 2, column 1, ending line 2, column 2: Found ‘<<’: Expecting: BEGIN DECLARE

  • Syntax error, found: ‘my_block’ at line 5, column 5. ERROR: line 5, column 5, ending line 5, column 12: Found ‘my_block’: Expecting: ;


#2

Hi, thank you for your feedback. We are investigating it.
We will update you with the progress.
br.Miroslav Stanik


#3

Can you executed the query even there are syntax errors?
thanks
Miroslav Stanik


#4

Greetings, Miroslav!

I cannot execute the query. I get the error “x”


#5

Hi, yes, but it is syntax error mark (false positive), can you try to execute the query? there is Execute action in toolbar
m.


#6

Hello Miroslav,

I tried to execute a function block that was supposed to output text, but it did not produce any output.


#7

Hi, right now there is output only for “RAISE EXCEPTION” in Toad Edge in Error view.
Other log levels ( DEBUG , LOG , INFO , NOTICE , WARNING) are not supported yet, but we plan to add this feature in future.
br.
Miroslav Stanik


#8

Hello,

Why is there a syntax error is being detected at the double left-caret symbols (“<<”) as the screen shot I sent you earlier shows?

The error is not occurring at the “RAISE NOTICE” statement.


#9

Hi, it is false positive syntax error, caused by wrong parsing in our parser library.

br.
Miroslav Stanik


#10

Greetings Miroslav,

Thank you for the update. A couple of questions:

  • Will the bug be fixed in the parser?

  • When will you support functionality for RAISE NOTICE?

Kelly


#11

Hi, parser issue will be fixed in 2.0.5, RAISE NOTICE is under development, we will let you know.
br.
Miroslav Stanik