Re: "Cluster" means "tangle" for me - Mailing list pgsql-general

From Tom Lane
Subject Re: "Cluster" means "tangle" for me
Date
Msg-id 10166.979182002@sss.pgh.pa.us
Whole thread Raw
In response to RE: "Cluster" means "tangle" for me  (Jeff Eckermann <jeckermann@verio.net>)
List pgsql-general
Jeff Eckermann <jeckermann@verio.net> writes:
> extracts=# cluster dc2_acct_i on dedcolo2;
> ERROR:  temp_28a1899 is an index relation
> extracts=# \d dedcolo
> Did not find any relation named "dedcolo".
> extracts=# \d temp_28a1899
>   Index "temp_28a1899"
>    Attribute   |  Type
> ---------------+---------
>  arbor_acct_no | integer
> btree

Now that I think about it, the "temp_xxx" name does not correspond to
what we use for temporary tables; rather it is the form of temporary
name under which the CLUSTER command creates the new table and index.
(Under the hood, CLUSTER builds the new table and index, then drops
the old ones and renames the new ones into place.  This is why you
lose all the other indexes and other decoration :-(.)

The cited error seems to indicate that CLUSTER is trying to open the
new index with heap_open instead of index_open.  If so, it'd fail
every time :-( ... but the new index and table ought to go away on
failure, not hang around.  So I'm still confused.

What version of Postgres did you say you are using?

            regards, tom lane

pgsql-general by date:

Previous
From: Ben Stringer
Date:
Subject: Casting money to numeric(10,2)
Next
From: The Hermit Hacker
Date:
Subject: PostgreSQL v7.1BETA3 Bundled and Available ...