From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Create clustered index |
Date: | 2012-04-04 20:53:05 |
Message-ID: | 1333572785.2315.63.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, 2012-04-04 at 18:17 +0200, Bartosz Dmytrak wrote:
> 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.
>
You're right about the issue. Your suggestion seems good to me. Bug
fixed according to your suggestion.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-04-04 20:54:49 | Re: Create clustered index |
Previous Message | Bartosz Dmytrak | 2012-04-04 16:17:07 | Create clustered index |