Alexander Farber <alexander.farber@xxxxxxxxx> wrote: > Thank you - > > On Mon, Feb 4, 2013 at 5:06 PM, Andreas Kretschmer > <akretschmer@xxxxxxxxxxxxx> 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° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
