Multiples commands.

Claudio · Post by **Claudio** » Mon 06 Apr 2009 20:43

I do not manage to execute multiples commands in a SQL.
Scripts:
update xxxxx;
update xxxxx;
....

Is this a BUG???

Plash · Post by **Plash** » Thu 16 Apr 2009 09:22

This not a bug. The driver prepares statement before executing it. PostgreSQL allows to have only one statement in the SQL text when PostgreSQL prepares SQL.

In the next build of the driver we'll add UnpreparedExecute extended driver option. If you set it to True, the driver uses simple query execution without preparation. So that you can add several statements to the SQL property.