Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Date
Msg-id 16315.1249309036@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT  (Kim Bisgaard <kim+pg@alleroedderne.adsl.dk>)
List pgsql-hackers
Tree view 
Kim Bisgaard <kim+pg@alleroedderne.adsl.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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Alpha releases: How to tag
Next
From: Tatsuo Ishii
Date:
Subject: CVS Head parser error?