RE: "Cluster" means "tangle" for me

I'm using version 7.00.
I know there has been a lot of bugs cleaned up since, but nothing that has
bitten me yet. I was hoping to hold off upgrading until the release of 7.1,
if that is what you would be suggesting ....

> -----Original Message-----
> From: Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, January 10, 2001 9:00 PM
> To: Jeff Eckermann
> Cc: 'pgsql-general(at)postgresql(dot)org'
> Subject: Re: [GENERAL] "Cluster" means "tangle" for me
>
> Jeff Eckermann <jeckermann(at)verio(dot)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