Michael Monnerie wrote:
> ERROR: CLUSTER cannot be executed from a function or multi-command
> I got this error from a script which tried:
> psql -U postgres db1 -c 'cluster ; analyze'
> In the docs there's no word that it's not possible, and I wonder why
> this is not allowed. Anybody knows? It's stupid, as I want to cluster
> lots of tables, followed by analyze, and now I have to
> psql -U postgres db1 -c 'cluster'
> psql -U postgres db1 -c 'analyze'
Multi-table cluster (i.e. the one where you don't specify one table to
cluster) cannot be used in a transaction block, function, etc, and the
FM does mention it:
CLUSTER without any parameter reclusters all the
previously-clustered tables in the current database that the calling
user owns, or all such tables if called by a superuser. This form of
CLUSTER cannot be executed inside a transaction block.
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-admin by date
|Next:||From: email@example.com||Date: 2009-04-29 15:28:20|
|Subject: Copy source and header files... ./config.sh: line 137: stem.c: No
such file or directory|
|Previous:||From: william pink||Date: 2009-04-29 12:36:45|
|Subject: Rather large Postgres directory|