Re: Create clustered index

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Create clustered index
Дата
Msg-id 1333572889.2315.65.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Create clustered index  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
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 "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.
> 

BTW, thanks for your report.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Create clustered index
Следующее
От: Colin Beckingham
Дата:
Сообщение: dev 1.15 wxwidgets 2.9.3 - adding constraints