X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CD5CBD1B8B5; Thu, 28 Aug 2003 03:59:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 31881-08; Thu, 28 Aug 2003 00:59:15 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id 04AC5D1B8CD; Thu, 28 Aug 2003 00:59:14 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h7S3x2Lt016361; Thu, 28 Aug 2003 11:59:02 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <039101c36d19$146ca3e0$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Bruno Wolff III" , "Tarhon-Onu Victor" Cc: , References: <20030828032356.GC7185@wolff.to> Subject: Re: [PERFORM] pgsql inserts problem Date: Thu, 28 Aug 2003 12:01:37 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/236 X-Sequence-Number: 6608 > > The problems is that only ~15% of the lines are inserted into > > the database. The same script modified to insert the same data in a > > similar table created in a MySQL database inserts 100%. > > Did you check the error status for the records that weren't entered? > > My first guess is that you have some bad data you are trying to insert. I wouldn't be surprised, MySQL will just insert a zero instead of failing in most cases :P Chris