Hi Yves,

> > > is firebird support auto increment data type?
> > > (
> > > like 'serial8' data type in postgresql.
> > > like 'bigint auto_increment' in mysql.
> > > )
> >
> > Yes, but its done through generators. Lookup generators in the docs.
>
> Has it never been considered to provide an "autoincrement" property for
> integer columns, as in other dbs?
>
> There seems to be popular demand for autoincrement, and it would surely
> help (non-dba)users (read "Access", etc...) to migrate to FB.

Actually, I think auto-inc fields are an abomination when it comes to multi
user etc access. Generators are much more powerful, and don't _have_ to
be used in triggers. I usually use them to get a number first, then INSERT
the new data. Very easy for any parent-child relationships you need to
establish as well.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com