Re: [GENERAL] cluster truncates table name?

Started by Ulf Mehligalmost 27 years ago1 messageshackersgeneral
Jump to latest
#1Ulf Mehlig
umehlig@uni-bremen.de
hackersgeneral

Bruce Momjian <maillist@candle.pha.pa.us>:

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

Why sorry? I'm happy if it doesn't appear in 6.5 ;-) But then, could
there be a misconfiguration or something like that in my 6.4(.0)
database, or could it be that the problem silently disappeared on the
way between 6.4 and 6.5? (I'm not moving to 6.5 beta because I have to
finish my theses, and nearly all the data is under postgreSQL ...)

Thank you anyway for your answer (and for postgreSQL ;-)

regards,
Ulf

----------------------------------------------------------------------

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!

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