Re: VACUUM cannot be executed from multi-command string

Sabin Coanda wrote:
> Hi there,
>
> I upgrade "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe
> (GCC) 3.4.2 (mingw-special)" to "PostgreSQL 8.3.5, compiled by Visual C++
> build 1400".
>
> I found the new Postgres version doesn't allowed to run a script file which
> contains multiline statements, which was working at the previous version.
> Trying to do it I get the error:
> ERROR: VACUUM cannot be executed from a function or multi-command string

> Can anybody help me to find a solution with the new vacuum constraint,
> without loosing the performance ?

Not without seeing the bit of the script causing problems.

How/why are you executing vacuum from your function / multi-command
string. I don't see why you have a multi-command string in a script.

--
Richard Huxton
Archonet Ltd