X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 713C352988 for ; Fri, 24 Jun 2005 11:57:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61969-07 for ; Fri, 24 Jun 2005 14:57:12 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 159E75290D for ; Fri, 24 Jun 2005 11:57:11 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA010BF5AE; Fri, 24 Jun 2005 10:56:58 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Fri, 24 Jun 2005 14:56:57 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE3009FC5AF; Fri, 24 Jun 2005 10:56:57 -0400 Received: from localhost (200.85.220.18) by cluster.surnet.cl (7.0.043) id 42B3EF60000E815A; Fri, 24 Jun 2005 10:56:55 -0400 Received: by localhost (Postfix, from userid 1000) id 35068C2D468; Fri, 24 Jun 2005 10:56:56 -0400 (CLT) Date: Fri, 24 Jun 2005 10:56:56 -0400 From: Alvaro Herrera To: Scott Marlowe Cc: ljh1469@alibaba-inc.com, "David.Bear@asu.edu" , pgsql-admin Subject: Re: psql copy errors Message-ID: <20050624145656.GA7762@surnet.cl> References: <20050624055243.3B13566C13B@smtp-hz> <1119624222.8208.67.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1119624222.8208.67.camel@state.g2switchworks.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.098 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: ** X-Archive-Number: 200506/199 X-Sequence-Number: 17954 On Fri, Jun 24, 2005 at 09:43:43AM -0500, Scott Marlowe wrote: > On Fri, 2005-06-24 at 00:52, ????????? wrote: > > David Bear: > > > > Yes. I agree with you. > > \copy is really too brittle. > > I wonder why \copy is not like oracle's sqlldr? > > I think sqlldr is more powerful. When using sqlldr,we can specify the maximum error records we allow,and we can also specify the number we should commit in every transaction. > > While I wouldn't mind have the versatility of sqlldr, I would HATE to > have to deal with such a clunky interface. The only features of sqlldr > I actually like are the ones that allow rejected records to go into a > separate file. There's a PGLoader project in pgfoundry that may suit some people. > > Another aspect is also important. Oracle has better partition > > table facilities,it's especially suitable for large tables,as > > well as index partition concepts.But PostgreSQL has no such > > concepts.These are really important for large database. > > No one would complain if someone stepped up and programmed a decent > table partitioning patch. I have a feeling it's one of the things on > the TODO list that will happen in the next version or two. I think Simon Riggs and crew are working on this. -- Alvaro Herrera () Jude: I wish humans laid eggs Ringlord: Why would you want humans to lay eggs? Jude: So I can eat them