View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 09:10 AM
Tom Lane
 
Posts: n/a
Default Re: Vacuum in multi-statement

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> This used to work in 8.2:
> psql postgres -c "VACUUM table1; SELECT now()"


> But in cvs head it throws an error:
> ERROR: VACUUM cannot be executed from a function or multi-command string


That's intentional. It "worked" only for rather small values of "work".

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote