I have implemented the Execute query feature and tested it with different kinds of test cases.
FYI the PostgreSQL Do block does not work as a single statement when we put the cursor inside the block at different positions.
The cursor position is mentioned using pipe('|') and underlined query is the active query that will run on click of Execute query button.
I have attached some screenshots for reference.
Please let me know if you have any questions.
That is exactly the sort of behaviour I was afraid of :-(. At least we have safeguards in place to minimise the chances of the user running something unexpected.
From:
Akshay Joshi Date: Subject:
Re: pgAgent Job issue: Couldn't get a connection to the database when local SQL mode specified in another database other than postgres