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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kim Bisgaard <kim+pg(at)alleroedderne(dot)adsl(dot)dk>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Date: 2009-08-03 14:17:16
Message-ID: 16315.1249309036@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kim Bisgaard <kim+pg(at)alleroedderne(dot)adsl(dot)dk> writes:
> Are there plans to make a small follow-up patch to make
> CREATE UNIQUE INDEX on one column
> (and variants in CREATE TABLE ... PRIMARY KEY) automatically do
> SET STATISTICS DISTINCT?

No. It would be pointless for a single column and wrong for
multiple columns.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2009-08-03 14:40:14 CVS Head parser error?
Previous Message Robert Haas 2009-08-03 12:52:52 Re: Alpha releases: How to tag