Re: [GENERAL] cluster truncates table name?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Ulf Mehlig <umehlig(at)uni-bremen(dot)de>
Cc: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] cluster truncates table name?
Date: 1999-05-10 16:46:27
Message-ID: 199905101646.MAA07734@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)zmt(dot)uni-bremen(dot)de>
> Center for Tropical Marine Ecology/ZMT, Bremen, Germany
> ----------------------------------------------------------------------
>
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonny Hinojosa 1999-05-10 19:26:36 RE: [GENERAL] pg_database corrupted(?) If so, what do I do????
Previous Message Ulf Mehlig 1999-05-10 16:38:57 Re: [GENERAL] cluster truncates table name?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-05-10 16:46:47 Re: [HACKERS] Beta2?
Previous Message Tom Lane 1999-05-10 16:44:37 Re: [HACKERS] "op must return bool to be used with subquery"?