Re: Create clustered index

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