Re: CLUSTER bug

This was fixed in 7.0.1.

> Sorry for a downer on an excellent piece of software.
>
> --
> Darren Steven
> Applications Specialist
> Networking Tasmania
> Telstra Australia
> Ph.1800 813 302
>
>

> If PostgreSQL failed to compile on your computer or you found a bug that
> is likely to be specific to one platform then please fill out this form
> and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)
>
> To report any other bug, fill out the form below and e-mail it to
> pgsql-bugs(at)postgresql(dot)org(dot)
>
> If you not only found the problem but solved it and generated a patch
> then e-mail it to pgsql-patches(at)postgresql(dot)org instead. Please use the
> command "diff -c" to generate the patch.
>
> You may also enter a bug report at http://www.postgresql.org/ instead of
> e-mail-ing this form.
>
> ============================================================================
> POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name : Darren Steven
> Your email address : dsteven(at)nettas(dot)telstra(dot)com(dot)au
>
>
> System Configuration
> ---------------------
> Architecture (example: Intel Pentium) : Intel PIII
>
> Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.14
>
> PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0
>
> Compiler used (example: gcc 2.8.0) : egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
>
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> CLUSTER fails and appears to corrupt database. I don't know if this happened on other releases, found it by mistake while playing with 7.0
>
> PS Great DB by the way.
>
>
>
> Please describe a way to repeat the problem. Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
> Create a database, create a table. insert some data. create index on one of fields. CLUSTER indexname ON tablename;
>
> With a large number of rows (so I can see it happeneing), I see the table being copied to a temp, and the renamed back to its original name. the problem is with the index :
>
> dws=# create index testind on accesslog (alclient);
> CREATE
> dws=# cluster testind on accesslog;
> ERROR: temp_674e00 is an index relation
>
>
> temp_674e00 appears to be a copy of the index file.
>
> psql now tells me the relation accesslog no longer exists
>
> the same error also occurs on small tables.
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
> Sorry. I've looked at cluster.c and if I fix it I'll post it.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026