Re: [Firebird-devel] Local table in repicated database

2021-01-25 Thread Leyne, Sean
Karol et al, Question about other DB engines which support separate ‘schemas’/’schema spaces’. Do they support FK references across schema? Sean From: liviuslivius Sent: Saturday, January 23, 2021 6:29 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] Local tabl

Re: [Firebird-devel] Local table in repicated database

2021-01-25 Thread Mark Rotteveel
On 25-01-2021 17:20, Leyne, Sean wrote: Question about other DB engines which support separate ‘schemas’/’schema spaces’.  Do they support FK references across schema? As far as I know, usually, yes. That is at least the case for databases where schemas are namespaces within a database. Mark

Re: [Firebird-devel] Local table in repicated database

2021-01-25 Thread liviuslivius
I do not know if my scenario is handled by new replication feature, but i suppose only way is not fixing replicator, only metadata commit stage. E.g. table publication cannot be disabled if table have referential constraints. But i do not know how this can be fixed in opposite direction. Two tab