> Oh of course generators are supperior, i don't argue that. What I'm
> suggesting is usability. Allowing someone to create a column with
> the key word "IDENTITY" or "PRIMARYKEY" or anything else and the
> database will do the automatic plumbing of creating the generator
> and trigger.

Next problem to solve - return the generated value back to the
application. Currently Firebird has no means to do this. So, that is
not so easy.

BTW, may I fill next RFC: "Implement INSERT INTO ... VALUES ...
RETURNS ..." that would also return some inserted values (useful for
INSERT statements that contain gen_id() calls).

Roman