cluster truncates table name?

Started by Ulf Mehligalmost 27 years ago2 messageshackersgeneral

umehlig@uni-bremen.de

almost 27 years ago

hackersgeneral

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
----------------------------------------------------------------------

Import Notes

Reply to msg id not found: 199904300300.XAA71364@hub.orgReference msg id not found: 199904300300.XAA71364@hub.org

Bruce Momjian

bruce@momjian.us

almost 27 years ago

In reply to: Ulf Mehlig (#1)

hackersgeneral

Re: [GENERAL] cluster truncates table name?

Sorry, I can't reproduce this here on 6.5beta.

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
----------------------------------------------------------------------

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