Horton

Thread

  1. Cluster fails

    Mark Kirkwood <markir@ihug.co.nz> — 2000-05-10T07:42:12Z

    Your name                     :Mark Kirkwood
Your email address      :markir@ihug.co.nz


System Configuration
---------------------
  Architecture (example: Intel Pentium)         :Intel Pentuim

  Operating System (example: Linux 2.0.26 ELF)  :Linux 2.2.14-5.0 ELF
(Redhat 6.2)

  PostgreSQL version (example: PostgreSQL-6.5.1):7.0RC4

  Compiler used (example:  gcc 2.8.0)           :egcs-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------
command  "cluster indexname on tablename" fails with text
"ERROR : temp123456abc is an index relation".
tablename and indexname are missing from pg_class, but
tablename still exists in the data directory


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

create table testit ( id integer);
create index testit_i on testit( id );
cluster testit_i on testit;

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------