Re: [pgadmin-support] Create clustered index

2012-04-04 Thread Guillaume Lelarge
On Wed, 2012-04-04 at 22:53 +0200, Guillaume Lelarge wrote: > 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 "

Re: [pgadmin-support] Create clustered index

2012-04-04 Thread Guillaume Lelarge
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 cr

[pgadmin-support] Create clustered index

2012-04-04 Thread Bartosz Dmytrak
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