| From: | "Peter Atkins" <patkins(at)directpartners(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Duplicate Row Removal |
| Date: | 2005-11-05 01:15:13 |
| Message-ID: | EABDD28F206C5E4FA5A658CC58111F8A045ED8A0@MAIL.directpartners.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Satoshi Nagayasu | 2005-11-05 01:51:45 | Re: RC1 gets crashed. |
| Previous Message | svn | 2005-11-04 21:20:26 | SVN Commit by dpage: r4664 - trunk/pgadmin3/pkg/win32/src |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-11-05 06:24:21 | Re: Duplicate Row Removal |
| Previous Message | Christopher Browne | 2005-11-04 23:51:10 | Re: Replicating databases |