X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id F330630FBA4
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 25 Jun 2003 08:16:48 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 74375-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 25 Jun 2003 05:16:38 -0300 (ADT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.186])
	by svr1.postgresql.org (Postfix) with ESMTP id 07F4230FB76
	for <pgsql-sql@postgresql.org>; Wed, 25 Jun 2003 05:16:38 -0300 (ADT)
Received: from [212.227.126.161] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 19V5SH-0000lm-00
	for pgsql-sql@postgresql.org; Wed, 25 Jun 2003 10:16:37 +0200
Received: from [217.230.197.16] (helo=ecologic.de)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 19V5SH-0002kT-00
	for pgsql-sql@postgresql.org; Wed, 25 Jun 2003 10:16:37 +0200
Message-ID: <3EF95A63.6070609@ecologic.de>
Date: Wed, 25 Jun 2003 10:16:35 +0200
From: Dani Oderbolz <oderbolz@ecologic.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.3.1) Gecko/20030425
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Delete duplicates
References: <20030622091522.M37248@oasis.net.au>
	<2976.200.59.66.253.1056316636.squirrel@webmail.akyasociados.com.ar>
	<00ac01c33946$8d1678e0$0a00000a@neo>
In-Reply-To: <00ac01c33946$8d1678e0$0a00000a@neo>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200306/289
X-Sequence-Number: 14047

Denis Arh wrote:

>How to delete "real" duplicates?
>
>id | somthing
>-----------------------
>1 | aaa
>1 | aaa
>2 | bbb
>2 | bbb
>
>(an accident with backup recovery...)
>
In these cases, its certainly the best to rebuild your table
using a

CREATE TABLE new AS
SELECT col1,col1..
FROM old
GROUPY BY col1,col2...

If you have got many duplicates, recreating a new table
semms better to me than deleteing.
(Another advantage is that you still have the "bad" table as a record).

Cheers,
Dani