Re: VACUUM cannot be executed from multi-command string - Mailing list pgsql-sql

From Richard Huxton
Subject Re: VACUUM cannot be executed from multi-command string
Date
Msg-id 49245585.5050205@archonet.com
Whole thread Raw
In response to VACUUM cannot be executed from multi-command string  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Sabin Coanda"
Date:
Subject: VACUUM cannot be executed from multi-command string
Next
From: Tom Lane
Date:
Subject: Re: Query to retrieve all indexed columns