How do I get auto-numbered Access/MS SQL fields to migrate ? - Mailing list pgadmin-support

From Greg
Subject How do I get auto-numbered Access/MS SQL fields to migrate ?
Date
Msg-id 000001c2b98b$f052b4e0$0a00a8c0@atlas
Whole thread Raw
List pgadmin-support
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.


pgadmin-support by date:

Previous
From: "Daniel"
Date:
Subject: Connection ODBC
Next
From: "Dave Page"
Date:
Subject: Re: How do I get auto-numbered Access/MS SQL fields to migrate ?