Bug in Migration Wizard 2.4.12 with 1-1 relationships
| От | Rohan Carly |
|---|---|
| Тема | Bug in Migration Wizard 2.4.12 with 1-1 relationships |
| Дата | |
| Msg-id | 001a01c2d9b7$5f4f99d0$0301a8c0@charcoal обсуждение исходный текст |
| Ответы |
Re: Bug in Migration Wizard 2.4.12 with 1-1 relationships
|
| Список | pgadmin-support |
I am trying to use the the Migration Wizard (version 2.4.12) to export a
simple Access database to Pgsql. I notice that the migration wizard fails,
if I have defined 1-1 relationships inside MS Access.
Here is the error log from the wizard:
>Creating table: address_table
> Copying data...
> Records Copied: 1
>Creating index: id
>Creating table: name_table
> Copying data...
> Records Copied: 1
>Creating index: id
>Creating Foreign Key: address_tablename_table
>
>An error occured at: 21/02/2003 10:25:58 PM:
>-2147467259: ERROR: parser: parse error at or near "("
>
>Rolling back... Done.
Here is the last bit of the postgres log from the server:
>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>'address_table_pkey
>' for table 'address_table'
>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>'name_table_pkey' f
>or table 'name_table'
>NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
>ERROR: parser: parse error at or near "("
>NOTICE: ROLLBACK: no transaction in progress
I have attached a very simple test case .mdb file which triggers the bug.
I use MS Access 2002 SP2 and PostgreSQL 7.2.
- Rohan Carly.
Вложения
В списке pgadmin-support по дате отправления: