Thread: cluster truncates table name?

cluster truncates table name?

From
Ulf Mehlig
Date:
Could there be a bug in the 'cluster' command in postgreSQL 6.4? If I
try to cluster a table with a name with more than 8 characters, psql
says:

  xxx=> create table x123456789 (xxx text);
  CREATE
  xxx=> create index x123 on x123456789 (xxx);
  CREATE
  xxx=> cluster x123 on x123456789;
  ERROR:  Relation x1234567  Does Not Exist!

If I try this repeatedly, I get:

  xxx=> cluster x123 on x123456789;
  ERROR:  temp_66c31 relation already exists

I'm running PostgreSQL 6.4(.0) on i386 Linux (2.2.6). Please excuse if
I overlooked something in the docs!

Bye, Ulf

--
======================================================================
Ulf Mehlig    <umehlig@zmt.uni-bremen.de>
              Center for Tropical Marine Ecology/ZMT, Bremen, Germany
----------------------------------------------------------------------