Vacuum in multi-statement

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Vacuum in multi-statement
Date: 2007-04-04 08:57:16
Message-ID: 4613686C.7050709@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

This must be because of the recent changes to PreventTransactionChain.

Should we try to keep the old behavior for backwards-compatibility? The
change will break some people's scripts, that's the way I noticed it.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-04-04 09:40:52 Re: Synchronized Scan benchmark results
Previous Message Marko Kreen 2007-04-04 08:41:05 Re: PL/Python warnings in CVS HEAD