Re: Import Wizard Error: Number 9, Subscript out of range

> -----Original Message-----
> From: Matthew J. Harmon [mailto:mjh+postgres(at)itys(dot)net]
> Sent: 12 February 2003 23:25
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Import Wizard Error: Number 9,
> Subscript out of range
>
>
> Searching through the pgadmin-support archives, I didn't see this
> error... Perhaps someone could assist me.
>
> I am using version 1.4.12 of pgAdmin II for Windows on a Windows 2000
> Professional system. PostgreSQL is installed (locally) via the 7.3.1
> Proof of Concept within Cygwin.
>
> Using the Import Wizard, I get the error:
> "An error has occured in Import Wizard:Import
> Wizard:fromWizard.cmdOK_Click:
>
> Number: 9
> Description: Subscript out of range
>
> The import is with a , (ASCII 44) delimiter with all commands
> and data
> surrounded by " (ASCII 34) and no trailing delimiter character.
>
> The file is about 15M, and is a straight pg dump. Trying to fix this
> without putting together a Perl script using ODBC ;).
> Recommendations?

Hi Matthew,

Please check there are no blank lines at the end of the file. If that
doesn't work, how many columns are in the import file? Can you send a
sample and the definition of the target table?

Regards, Dave.