Deleting duplicate records - Mailing list pgsql-interfaces

From Paul S. Ganney
Subject Deleting duplicate records
Date
Msg-id 384D39E6.6459@dial.pipex.com
Whole thread Raw
Responses Re: [INTERFACES] Deleting duplicate records  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
This probably sounds horribly trivial, but still...

I've managed to get some duplicate records in a table and am having 
problems getting rid of them (as there's nothing unique to SELECT on). 
Any ideas?

And whilst I'm at it - any ideas on a scheme for preventing duplicates?

Paul.
-- 
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------



pgsql-interfaces by date:

Previous
From: Gary Stainburn
Date:
Subject: RE: [INTERFACES] locking on database updates
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [INTERFACES] locking on database updates