Re: Adding PRIMARY KEY: Table contains duplicated values

Alexander Farber <alexander.farber@gmail.com> wrote:

> Thank you -
>
> On Mon, Feb 4, 2013 at 5:06 PM, Andreas Kretschmer
> <akretschmer@spamfence.net> wrote:
> >> # alter table pref_rep add primary key(id, author);
> >> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> >> "pref_rep_pkey" for table "pref_rep"
> >> ERROR:  could not create unique index "pref_rep_pkey"
> >> DETAIL:  Table contains duplicated values.
>
> how do you get this DETAIL, is it a setting for psql prompt?

You means the 'DETAIL:  Key (id1, id2)=(1, 2) is duplicated.'?

I'm using 9.2, i think, that's the reason.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°