Subject Re: [Firebird-Architect] Re: autoincrement fields
Author Ann W. Harrison
> a) our gbak has problem with restoring the tables containing "DEFAULT
> gen_id(....)" - for some reason generators are created after the
> tables. The fix is not trivial.

What's not trivial about changing the order of backup so objects
without dependencies (e.g. generators) are backed up before objects
with dependencies?
> b) systems with autoincrement fields (at least MS Access, MS SQL
> Server and MySQL) do not have INSERT ... INTO ... RETURNING, but use
> some kind of "SELECT @@lastval" statement. So even if we provide an
> autoincrement type, there still will be some effort to port the
> application.