Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 879D1476061 for ; Mon, 28 Oct 2002 16:22:06 -0500 (EST) Received: from utahisp.com (unknown [66.239.12.3]) by postgresql.org (Postfix) with ESMTP id 5E0EE475D99 for ; Mon, 28 Oct 2002 16:22:04 -0500 (EST) Received: from chad [63.230.8.76] by utahisp.com (SMTPD32-5.05) id A9F83A870294; Mon, 28 Oct 2002 14:19:52 -0700 Message-ID: <10a801c27ec8$0faa1940$32021aac@chad> From: "Chad Thompson" To: "peter" , "pgsql-sql" References: Subject: Re: subscrip out of range Date: Mon, 28 Oct 2002 14:22:02 -0700 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.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Declude-Sender: chad@weblinkservices.com [63.230.8.76] X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/383 X-Sequence-Number: 10100 "subscript out of range" is an error that means you are trying to access part of an array that doesnt exist. It probably means that your data doesnt have all the fields for all the records. Check to see if your data is truncated or if there is an unusual (usually shortened) number of fields in a given record. HTH Chad ----- Original Message ----- From: "peter" To: Sent: Saturday, October 26, 2002 1:25 AM Subject: [SQL] subscrip out of range > i am getting this error when iimport data using the pgaccess client from a > txt file. I will import some records then crash out. Any IDeas? > > has it got anything to do with the primary key on the destination table and > if so how do you temporaryily disable it > > Thanks for any hellp > > PEter > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >