Hi Greg, Could you recreate just one or two of the errors (ie. Just migrate a couple of table) with logging turned to 'Errors and SQL Queries' under tools -> options and send the logfile please?
Regards, Dave. > -----Original Message----- > From: Greg [mailto:[EMAIL PROTECTED]] > Sent: 11 January 2003 16:10 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] How do I get auto-numbered > Access/MS SQL fields to migrate ? > > > I am using pgAdminII to try to convert data in either Access > or MS SQL Server 7 to a PostgreSQL database on a Suse box. I > am trying to get the Northwinds database to convert as a > proof of concept project. Apparently the AutoNumber field has > problems converting. > > Any pointers would be helpful. My log errors are pasted here > if it helps. > > TIA > > Greg Canter > > Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 10:59:46 AM: > -2147467259: ERROR: Unable to locate type name 'lo' in catalog > > Rolling back... Done.Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 11:00:03 AM: > -2147467259: ERROR: Unable to locate type name 'lo' in catalog > > Rolling back... Done.Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 11:03:15 AM: > -2147467259: ERROR: parser: parse error at or near "," > > Rolling back... Done.Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 11:03:20 AM: > -2147467259: ERROR: parser: parse error at or near "," > > Rolling back... Done.Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 11:03:21 AM: > -2147467259: ERROR: parser: parse error at or near "," > > Rolling back... Done.Creating table: Categories > Creating sequence Categories_CategoryID_key > > An error occured at: 1/11/2003 11:05:03 AM: > -2147467259: ERROR: parser: parse error at or near "," > > Rolling back... Done. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
