From: | "Greg" <runman(at)telocity(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | How do I get auto-numbered Access/MS SQL fields to migrate ? |
Date: | 2003-01-11 16:10:20 |
Message-ID: | 000001c2b98b$f052b4e0$0a00a8c0@atlas |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-01-12 22:17:09 | Re: How do I get auto-numbered Access/MS SQL fields to migrate ? |
Previous Message | Daniel | 2003-01-10 14:38:38 | Connection ODBC |