|Subject||RE: [IBDI] Internet|
|Author||Claudio Valderrama C.|
> -----Original Message-----You seem to be the only person that says like me that this is a problem.
> 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 !! :-)
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.