Postgres Pro
Downloads
Home   >   mailing lists

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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Duplicate Row Removal  ("Dean Gibson (DB Administrator)" <postgresql4@ultimeth.com>)
List pgsql-general
Tree view 
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