Re: How do I get auto-numbered Access/MS SQL fields to migrate ?

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:runman(at)telocity(dot)com]
> Sent: 11 January 2003 16:10
> To: pgadmin-support(at)postgresql(dot)org
> 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