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

Sat, 1 May 1999 13:16:11 +0200
Ulf Mehlig <umehlig@uni-bremen.de>
cluster truncates table name?
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
----------------------------------------------------------------------

Mon, 10 May 1999 18:38:57 +0200
Ulf Mehlig <umehlig@uni-bremen.de>
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

Mon, 10 May 1999 12:46:27 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [GENERAL] cluster truncates table name?