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 по дате отправления: