> -----Original Message----- > From: Matthew J. Harmon [mailto:[EMAIL PROTECTED]] > Sent: 12 February 2003 23:25 > To: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org