Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DD0B59FB2F1 for ; Sat, 19 May 2007 20:58:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 75360-01 for ; Sat, 19 May 2007 20:57:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54309.mail.yahoo.com (web54309.mail.yahoo.com [206.190.49.119]) by postgresql.org (Postfix) with SMTP id 15A999FB295 for ; Sat, 19 May 2007 20:58:14 -0300 (ADT) Received: (qmail 52166 invoked by uid 60001); 19 May 2007 23:58:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Kmvnttd8ystItqPPpVst9BH0KhFaYy4icnUjELhv0I36u9j85C8mP55BtKJhL5UW0SSv6FVlZDXuXfyFJsl05IBE1OhjMldw9K2Qpugj7m0QRB2COE/jIzL6ksTaQBq5rSrhtIUXwXUTnWuOvl6VWGuYdbgUBoH6SjPnH9josSc=; X-YMail-OSG: 6EItwmwVM1kEPaoQIc_5O5ekLOnd3IK6LvuVk53i7gin2YJVq6ODbbaMAb1GETAG_2fUbgd8fKb9wmv_eXeJycvAoBPFfZzKzpu1WkaFx9_OXiDqMVr2zufh1WnZbMJf5DHU6KRkaBwzjl7PHO3N_Ls_ Received: from [24.2.63.115] by web54309.mail.yahoo.com via HTTP; Sat, 19 May 2007 16:58:13 PDT Date: Sat, 19 May 2007 16:58:13 -0700 (PDT) From: chester c young Subject: Re: ignoring primary key violations in COPY command To: Paul Lambert Cc: sql pgsql In-Reply-To: <464F7A31.6020501@autoledgers.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <567285.51917.qm@web54309.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/148 X-Sequence-Number: 28428 > In my opinion your best bet in terms of getting around the primary > key > violation is to create a temporary table ... good idea! from my experience it's almost always best to pull raw info into a buffer table before introducing it into the real world. ____________________________________________________________________________________ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front