Documentation bug: Chapter 35.4, paragraph 4 - Mailing list pgsql-bugs

From Jonathan Pool
Subject Documentation bug: Chapter 35.4, paragraph 4
Date
Msg-id 014DFDA2-CF76-4DB1-B3C2-0550BAE1A705@utilika.org
Whole thread Raw
Responses Re: Documentation bug: Chapter 35.4, paragraph 4
List pgsql-bugs
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 da=
ta modification queries (INSERT, UPDATE, and DELETE), as well as other SQL =
commands. (The only exception is that you cannot put BEGIN, COMMIT, ROLLBAC=
K, or SAVEPOINT commands into a SQL function.)

This appears to be incorrect, in that attempting to include a VACUUM comman=
d 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5763: pg_hba.conf not honored
Next
From: "abraham camacho"
Date:
Subject: BUG #5764: installation error (incomplete process)