Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 848689F99C9 for ; Mon, 27 Aug 2007 23:15:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 46773-03 for ; Mon, 27 Aug 2007 23:15:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web58114.mail.re3.yahoo.com (web58114.mail.re3.yahoo.com [68.142.236.137]) by postgresql.org (Postfix) with SMTP id 28F119F9594 for ; Mon, 27 Aug 2007 23:15:26 -0300 (ADT) Received: (qmail 82001 invoked by uid 60001); 28 Aug 2007 02:15:24 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=MfnEW6v9YTgenidJAzADO0rLcT9s2zSA09ts+DZZi0bc+obB+pDKZondir4iWtLR3MaA1SFMDaCrt/3yO04I4Jals15C+ybABeIZhj5Re+tXpUPC6Ef58YitLjI6AIUeU+D17V421FRvX9W7dQOj2pxl36d6NYTZJpC0M1gQT4s=; X-YMail-OSG: 0jBbLjQVM1mtNXOUZYTB4cxwciMsO2ZopdOdyKprSszpNejzBq7EwXIw7wnSr6T1pYixCDQyAb6yUkQNqMHOpB8d_w-- Received: from [219.142.118.227] by web58114.mail.re3.yahoo.com via HTTP; Tue, 28 Aug 2007 10:15:24 CST Date: Tue, 28 Aug 2007 10:15:24 +0800 (CST) From: Reply-To: qinghuamail-postgresqlfans@yahoo.com Subject: =?gb2312?q?=D7=AA=B7=A2=A3=BA=20=20Copy=20cmd=20error?= To: postgresql-admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-210024643-1188267324=:81359" Content-Transfer-Encoding: 8bit Message-ID: <578352.81359.qm@web58114.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.501 tagged_above=0 required=5 tests=AWL=0.499, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200708/338 X-Sequence-Number: 26669 --0-210024643-1188267324=:81359 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit hi, after reading the source of pgloader,i have a idea,use perl to create the flat file, and, when error,reject the row,seek the next line,continue to copy. thanks everyone. qinghuamail-postgresqlfans@yahoo.com 写道: 日期: Mon, 27 Aug 2007 16:18:35 +0800 (CST) 发件人: 主题: [ADMIN] Copy cmd error 收件人: postgresql-admin hi,all I use COPY cmd to import large data to database,but I have a question, when occured the first error, It always stopped, I need it to be continue,and reject the error rows to a file, how to do this? thanks! --------------------------------- 雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-210024643-1188267324=:81359 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit hi, after reading the source of pgloader,i have a idea,use perl to create the flat file, and, when error,reject the row,seek the next line,continue to copy.

thanks everyone.

qinghuamail-postgresqlfans@yahoo.com 写道:
日期: Mon, 27 Aug 2007 16:18:35 +0800 (CST)
发件人: <qinghuamail-postgresqlfans@yahoo.com>
主题: [ADMIN] Copy cmd error
收件人: postgresql-admin <pgsql-admin@postgresql.org>

hi,all

I use COPY cmd to import large data to database,but I have a question,

when occured the first error, It always stopped, I need it to be continue,and reject the error rows to a file, how to do this?

thanks!




雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-210024643-1188267324=:81359--