03.04.2018 7:19, 'Joje' j...@codework-solutions.com [firebird-support] wrote:
> _Trigger that calls generator is fired on insertion:_
Try to add some logging into this trigger to detect cases when record is
inserted with
application-provided _ID and thus generator is not used.
--
WBR,
On 03/04/18 06:19, 'Joje' j...@codework-solutions.com [firebird-support]
wrote:
> SET GENERATOR _ID_GEN TO 16594028
Of cause you only need that to fix the current problem. A set query
should not exist in the normal code.
--
Lester Caine - G8HFL
-
Contact -
been an FB issue then it would have been replicated on somewhere
else also.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 02 April 2018 06:12 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Auto-increment
. George
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: 02 April 2018 09:27 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Auto-increment generating old ID's for insertion
On 2-4-2018 14:11, 'Joje' j...@codework
On 2-4-2018 14:11, 'Joje' j...@codework-solutions.com [firebird-support]
wrote:
> I have issue where auto-increment of ID column is generating older ID’s
> that is already used in table.
>
> Currently, my transaction table has around 16 million rows and *ID of
> last inserted row is
On 02/04/18 13:11, 'Joje' j...@codework-solutions.com [firebird-support]
wrote:
> I have issue where auto-increment of ID column is generating older ID’s
> that is already used in table.
>
> Currently, my transaction table has around 16 million rows and *ID of
> last inserted row is
Hello,
I have issue where auto-increment of ID column is generating older ID's that
is already used in table.
Currently, my transaction table has around 16 million rows and ID of last
inserted row is 16,594,027. While the generator ID its 16,593,965. As you
can see the generator is