Tim

When migrating a database is it possible to select which of the following two approaches is used for autoincs?

"three" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
"four" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1)


Roy Lambert

ps - pretty sneaky having a directory for each migrator - took me about 15mins to realise the damn thing wasn't a dll

Roy,

<< When migrating a database is it possible to select which of the following
two approaches is used for autoincs?

"three" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY
1),
"four" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY
1) >>

I'll see what I can do.  Right now it defaults to the same behavior as
DBISAM, i.e. BY DEFAULT.

<< ps - pretty sneaky having a directory for each migrator - took me about
15mins to realise the damn thing wasn't a dll >>

It's our build system - it's set up to do a separate directory for every
library (DLL).

--
Tim Young
Elevate Software
www.elevatesoft.com