[Linux dev] SQL duplicate entries

[Hendrik Visage <hvisage@xxxxxxxxxxxxxx>]

Hi there,

 I'd like to find duplicate entries for a SQL table.
ie. only the duplicate entries for a certain key. (preferably Postgres,
but open for examples/suggestions from other RDBMS)

 The problem behind the question is that I have RADIUS accounting logs that
appears to contain duplicate entries (h323_conf_id which should be unique),
and I'd like to compare the duplicate h323_conf_id entries to see if it's
a "legal" duplicate entry (ie. Radius "double" logging because of network
troubles etc.) or a re-use/cross-use of h323_conf_ids in this/other routers.

I'll consider doing a primary key on the full record only as a last resort for
performance reasons :(

(And before anybody ask, no, it's not a VoIP network that's in ZA :()

Hendrik