On 23/01/2021 08:35, Dmitry Yemanov wrote: > 23.01.2021 14:20, Dimitry Sibiryakov wrote: >> >> Is there a way to create a local, non-replicated table in a replicated >> database? >> >> I.e. neither "create table" itself nor following DML must be replicated. > > CREATE TABLE is currently always replicated. The table data may be > excluded though. And here we have a good question - if CREATE TABLE > specifies DISABLE PUBLICATION, should the CREATE TABLE command itself be > replicated or not? It could solve your need, but if later one decides to > enable publication, it's not gonna work and the replication stream will > be broken (missing table at the replica side). >
If the table metadata is not replicated, there may be problem with stored routines using it. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
