Re: CLUSTER trashing indexes

Jason Davis <jdavis(at)tassie(dot)net(dot)au> writes:
> Have I missed something in the release notes or known bugs list,

From the CLUSTER manual page:

: The table is actually copied to a temporary table in index order, then
: renamed back to the original name. For this reason, all grant
: permissions and other indexes are lost when clustering is performed.

The man page fails to point out that you also lose constraints, etc.
What's left after cluster is not much except the data and the one index.
You can rebuild all that stuff, but it's a pain to have to do so.

This is a really sucky implementation, and fixing it has been on the
TODO list for a long time. We need a way of doing filename versioning
first...

regards, tom lane