Create clustered index

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Create clustered index
Date: 2012-04-04 16:17:07
Message-ID: CAD8_UcZCWNYmA15UEmvnq-6+6a+r1BV2FPDC6U64H2V6f6EZEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
I've tried to create clustered index on table, pgAdmin generated SQL:
CREATE INDEX
ON "Calc"."tblDBObjectsDefs" (fullname ASC NULLS LAST);
ALTER TABLE "Calc"."tblDBObjectsDefs" CLUSTER ON ;

Problem is that I tried to create unnamed index, to allow DB to name it.
Because of that, ALTER TABLE statement is not valid (no index name after
CLUSTER ON).

My suggestion is to disallow create clustered indexes when there is no
explicit name given by the user.

Regards,
Bartek

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-04-04 20:53:05 Re: Create clustered index
Previous Message Mephysto 2012-03-30 07:52:36 Re: Column prosrc of table pg_proc