| 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: | Whole Thread | Raw Message | 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... |