pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

subscrip out of range
2+ messages / 2 participants
[nested] [flat]

* subscrip out of range
@ 2002-10-26 08:25  peter <peter@peter.com>
  0 siblings, 1 reply; 2+ messages in thread

From: peter @ 2002-10-26 08:25 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: subscrip out of range
@ 2002-10-28 21:22  Chad Thompson <chad@weblinkservices.com>
  parent: peter <peter@peter.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Chad Thompson @ 2002-10-28 21:22 UTC (permalink / raw)
  To: peter <peter@peter.com>; 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@peter.com>
To: <pgsql-sql@postgresql.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@postgresql.org
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-10-28 21:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-26 08:25 subscrip out of range peter <peter@peter.com>
2002-10-28 21:22 ` Chad Thompson <chad@weblinkservices.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox