============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Tim Webster
Your email address : [email protected]
Category : runtime: back-end: SQL
Severity : serious
Summary: can't create clusters for some tables
System Configuration
--------------------
Operating System : LinuxPPC, Release 4
PostgreSQL version : 6.4
Compiler used : gcc
Hardware:
---------
PPC, 64M RAM
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
Somewhere, somehow, the last characters of some (but not all) tables' names are dropped, causing the cluster command to fail, i.e.:
switchboard=> create index jobscoresidx on jobscores(jobnum);
CREATE
switchboard=> cluster jobscoresidx on jobscores;
ERROR: Relation jobscore Does Not Exist!
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------