"Wang, Mary Y" <mary.y.wang@xxxxxxxxxx> writes: > What would be the newer version of pgsql (I mean a bit higher version of my current version) that provides that capability of telling me what the duplicated key was ? Hmm ... [ experiments... ] For the specific case of COPY into a table with a pre-existing unique index, it looks like only CVS HEAD will give you an error message with the exact index value. However, everything back to 7.4 will include the text of the whole current line of COPY data, which probably would be enough to figure out the problem. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
