Subject [Firebird-Architect] Auto-increment/-generated fields and getting values back
Author Dmitry Yemanov
"Roman Rokytskyy" <rrokytskyy@...> wrote:
>
> Yes, but that's completely different thing. The original talk was
> about adding some kind of an autoincrement field that would
> automatically fetch its value from generator.

The SQL-99 spec contains both sequences/generators and
identity/autoincrement columns. What one needs is to read the spec and
submit a feature request to the tracker. Or present it here, although,
unfortunately, we still don't a dedicated person to summarize fb-arch
discussions, so every proposal has quite good chances to be lost in dust.

> What you propose is to fetch the ID first on the client, and then use
> it in INSERT. Perfect solution, but it will not help those that are
> too used to autoincrement fields and getGeneratedKeys() in JDBC.

See my other message.


Dmitry