Duplicate Row Removal - Mailing list pgsql-general

From Peter Atkins
Subject Duplicate Row Removal
Date
Msg-id EABDD28F206C5E4FA5A658CC58111F8A045ED8A0@MAIL.directpartners.com
Whole thread Raw
Responses Re: Duplicate Row Removal
Re: Duplicate Row Removal
List pgsql-general
All,

I have a duplicate row problem and to make matters worse some tables
don't have a PK or any unique identifier. See below:

uid | cleanval | timestamp  | received
-----+-------+------------+----------
  38 |     5 | 1125081799 |        1
  38 |    14 | 1122683252 |        0
  38 |     5 | 1125081799 |        1
  38 |    14 | 1122683252 |        0


I was hoping to have a system oid for each row but it looks like that's
not the case. Anyone have any thoughts on how to remove dups? I have
about 40 tables of various sizes.

Cheers,
Peter



pgsql-general by date:

Previous
From: Marc Boucher
Date:
Subject: Re: Changing ids conflicting with serial values?
Next
From: Tom Lane
Date:
Subject: Re: Duplicate Row Removal