Обсуждение: 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,
Pennsylvania19026
 

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