Re: subscrip out of range

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "peter" <peter(at)peter(dot)com>, "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: subscrip out of range
Date: 2002-10-28 21:22:02
Message-ID: 10a801c27ec8$0faa1940$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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" <peter(at)peter(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
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(at)postgresql(dot)org
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-10-29 01:06:39 BOOLEAN question
Previous Message marnaudo@inwind.it 2002-10-28 19:57:02 psql history