Devart Forums

I am just testing dbForge Studio for Postgres to replace my old PgAdmin 3.

I like it, but I wonder why do I get an error

cannot insert multiple commands into a prepared statement

if I run some code using the "DO" command block?

Here is a sample code that runs from PgAdmin and dbFiddle with no problem:

https://dbfiddle.uk/?rdbms=postgres_9.6 ... c9038eabe0

But when I run it from the dbForge Studio, the error occurs.

We will fix this bug in the next version of Studio.

Also you could use $plpgsql$ or $sql$ instead of $$.
In this case you could use code highlights and code completion in plpgsql blocks, functions etc.