Hello,
We found a problem with the Database Migration wizard and Access 2002:
If we have a sequence in a table in Access 2002 and use the Migration
Wizard to put the table into Postgres, the SQL-Statement for inserting
the next value in the table is wrong. For example:
Migration Wizard produces:
mycolumn int4 DEFAULT nextval("'mycolumn_seq'"::text) NOT NULL
^^ ^^
this is the error -> ' "
and correct it should be:
mycolumn int4 DEFAULT nextval('myschema.mycolumn_seq'::text) NOT NULL
^^ ^^
The difference -> only '
and: the schemaname is not inserted, too.
But: The Migration wizard is *the* "Killer App" for our work ;-)
:-)
With Sequences created in Access 97, there is no problem!
Greetings,
Albin
--
************************************************************************
** Albin Blaschka, Mag. rer. nat.
** BAL Gumpenstein
** Projekt: Landschaft und Landwirtschaft im Wandel
** Tel.: 03682 / 22451 - 244
** No trees were killed in the creation of this message.
** However, many electrons were terrible inconvenienced.
************************************************************************
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
