Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DF1B92E00CC for ; Sun, 16 Dec 2007 02:39:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16019-07 for ; Sun, 16 Dec 2007 02:39:31 -0400 (AST) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.184]) by postgresql.org (Postfix) with ESMTP id B384F2E00C8 for ; Sun, 16 Dec 2007 02:39:33 -0400 (AST) Received: by fk-out-0910.google.com with SMTP id b27so817529fka.3 for ; Sat, 15 Dec 2007 22:39:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=t9wWfoA9OZ4qrlSRd3nk31PGSUyzl2YgD9g+f7LHb7k=; b=f8OU74FmhaR312x3t67cJffsNcMFbLN85BmSFIviQLwyPnqptJg2TvLNEt+ARtBB/EA2GanyAqGyWihdRILcxBxQTE2hr6FrXVeDEO+FDgu+AfUAQg1p4i5Is0tb65KqRygRDVtfRV2TK1+I8kDTHrGH9Nx8Gc7PoztiRTSB03g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=q8IfOeGIh40zPUTSD423lpxkhK+rYgdtW4pfj5f/TDf/yRGy5Mxh/m+/ec1BiBk1/BuLPPREhAdmkrHdXbltkSDH+gKlBPhiZ9K7tcH5ws0VHOJRVrsvpAN9Q6//Nz4EB0xkwayDTGmMJT6M1orQos785T6SztG3xDGEQMvaTiM= Received: by 10.78.145.14 with SMTP id s14mr6325400hud.58.1197787172447; Sat, 15 Dec 2007 22:39:32 -0800 (PST) Received: by 10.78.35.10 with HTTP; Sat, 15 Dec 2007 22:39:32 -0800 (PST) Message-ID: <162867790712152239s291430fakfe0fbe40d71a0357@mail.gmail.com> Date: Sun, 16 Dec 2007 07:39:32 +0100 From: "Pavel Stehule" To: "Neil Conway" Subject: Re: VLDB Features Cc: "Greg Smith" , "Josh Berkus" , pgsql-hackers@postgresql.org In-Reply-To: <1197785266.6164.7.camel@goldbach> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1197371508.4255.1327.camel@ebony.site> <200712111053.11178.josh@agliodbs.com> <1197785266.6164.7.camel@goldbach> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/605 X-Sequence-Number: 111894 On 16/12/2007, Neil Conway wrote: > On Tue, 2007-12-11 at 19:11 -0500, Greg Smith wrote: > > I'm curious what you feel is missing that pgloader doesn't fill that > > requirement: http://pgfoundry.org/projects/pgloader/ > > For complicated ETL, I agree that using an external tool makes the most > sense. But I think there is still merit in adding support to COPY for > the simple case of trying to load a data file that has some corrupted, > invalid or duplicate records. > > -Neil > > Any simple enhancing of COPY is welcome. I lost lot of time with repeated imports. Regards Pavel > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >