Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Дата
Msg-id 603c8f070907312108y22c61ae4le4c15e4fcc77157f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-hackers
On Fri, Jul 31, 2009 at 11:09 AM, Dimitri
Fontaine<dfontaine@hi-media.com> wrote:
> I failed to have 0 to allow for analyze to compute a value again, as shown
> in the raw notes in attachement:

I'm lost.  I think you're getting the new column attdistinct mixed up
with the existing column stadistinct.  attdistinct is always going to
have whatever value you assign it.  stadistinct will get attdistinct
!= 0 ? attdistinct : <result of analyze calculation>.

...Robert


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Revised signal multiplexer patch
Следующее
От: Robert Haas
Дата:
Сообщение: Re: machine-readable explain output v2