From: | Ulf Mehlig <umehlig(at)uni-bremen(dot)de> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | cluster truncates table name? |
Date: | 1999-05-01 11:16:11 |
Message-ID: | 199905011116.NAA14574@pandora3.localnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
----------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Simeone | 1999-05-01 11:16:18 | |
Previous Message | M Simms | 1999-05-01 02:14:29 | Query I cannot work out |
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1999-05-01 11:57:00 | DeadLockCheck... |
Previous Message | Vadim Mikheev | 1999-05-01 08:23:22 | locking... |