From: Jonathan Pool <pool@utilika.org>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Documentation bug: Chapter 35.4, paragraph 4
Date: Tue, 23 Nov 2010 10:08:07 -0800
Message-Id: <014DFDA2-CF76-4DB1-B3C2-0550BAE1A705@utilika.org>
Cc: Susan Colowick <smc@utilika.org>
To: pgsql-bugs@postgresql.org
Mime-Version: 1.0 (Apple Message framework v1082)

Chapter 35.4, paragraph 4, of the PostgreSQL 9.0.1 Documentation says:

Any collection of commands in the SQL language can be packaged together =
and defined as a function. Besides SELECT queries, the commands can =
include data modification queries (INSERT, UPDATE, and DELETE), as well =
as other SQL commands. (The only exception is that you cannot put BEGIN, =
COMMIT, ROLLBACK, or SAVEPOINT commands into a SQL function.)

This appears to be incorrect, in that attempting to include a VACUUM =
command in a query-language function elicits the following error =
message:

ERROR:  VACUUM cannot be executed from a function or multi-command =
string

Thus, presumably "VACUUM" should be added to the list of exceptions.
=CB=89