Request a Demo
Home   >   mailing lists

Create clustered index - Mailing list pgadmin-support

From Bartosz Dmytrak
Subject Create clustered index
Date
Msg-id CAD8_UcZCWNYmA15UEmvnq-6+6a+r1BV2FPDC6U64H2V6f6EZEw@mail.gmail.com
Whole thread Raw
Responses Re: Create clustered index
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Mephysto
Date:
Subject: Re: Column prosrc of table pg_proc
Next
From: Guillaume Lelarge
Date:
Subject: Re: Create clustered index