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@sss.pgh.pa.us]
> Sent:    Wednesday, January 10, 2001 9:00 PM
> To:    Jeff Eckermann
> Cc:    'pgsql-general@postgresql.org'
> Subject:    Re: [GENERAL] "Cluster" means "tangle" for me
>
> 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