Gerry Jensen <gerry(at)xmission(dot)com> writes:
> I issued the following command[s]:
> select distinct on (symbol, date) * into price from pricebackup;
> 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.
Um, isn't pricebackup the one that still has the dup rows? You should
have created the index on the new table.
regards, tom lane