> -----Original Message-----
> From: Peter Morris [mailto:pmorris@...]
> Sent: Miércoles 6 de Junio de 2001 14:14
>
> select GEN_ID(GEN_TEST,1) from RDB$Database
>
> Even though sysdba created the generator, someone never given
> permission to
> anything can go in and happily waste generator numbers, tell me
> that isn't a
> problem !! :-)

You seem to be the only person that says like me that this is a problem.
It's not only about wasting numbers. By moving the generator backwards, I
can make insertions fail if the generator feeds a PK, since Gen_id accepts
arbitrary integer argument as the increment, including negative values.

C.