Re: duplicate rows mystery

On Thu, Apr 14, 2005 at 03:26:16AM -0600, Gerry Jensen wrote:
>
> select distinct on (symbol, date) * into price from pricebackup;
>
> It did indeed remove several rows that had duplicate items. I then tried
> to build a unique index on the columns (symbol, date) in pricebackup with:
>
> create unique index price_symbol_date on pricebackup (symbol, date);
>
> and got the error:
>
> ERROR: could not create unique index
> DETAIL: Table contains duplicated values.

If the SELECT and CREATE statements are what you really did, then
you tried to create an index on the original table (pricebackup),
not the table you SELECTed into (price). Are you sure you have the
right table names in the right places?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/