Ok, let's see the following example:
Master:
CREATE SEQUENCE TMP_GEN_2;
commit;
CREATE TABLE TMP_TABLE (
VC VARCHAR(10)
);
commit;
CREATE OR ALTER TRIGGER TMP_TABLE_BIU0 FOR TMP_TABLE
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
as
declare variable dummy integer;
begin
dummy = gen_id(tmp_gen_2, 1);
end
commit;
insert into TMP_TABLE (VC) values ('A');
commit;
-- At this point in master and replica's generator has the same value: 1
update tmp_table set vc = 'B';
commit;
-- At this point master's generator value is 2, but the replica's generator
value is 1.
The last update is a commited DML...
CÉGÜNK A LIBRA CSOPORT TAGJA
OMACHT ANDRÁS
fejlesztési igazgató
LIBRA Szoftver Zrt.
1113 Budapest, Karolina út 65.
+36 (1) 255-3939
[email protected] | www.libra.hu
-----Original Message-----
From: Dimitry Sibiryakov [mailto:[email protected]]
Sent: Tuesday, May 18, 2021 1:23 PM
To: For discussion among Firebird Developers
<[email protected]>
Subject: Re: [Firebird-devel] Replication - generators' value are not replicated
18.05.2021 13:20, Omacht András wrote:
> I commited, as shown in my example.
Transaction also must contain some DML. Without it replication of generator
is pointless.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
