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
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
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
I will not be concerning at it at all. As simple other scensrio cause more
problems.Consider 2 tables with already replicated metadata. Second table have
foreign key on first. But only second table data are replicated but first not.
To what data foreign key will reference in replicated database?
On 23-01-2021 14:42, Dimitry Sibiryakov wrote:
23.01.2021 14:20, Mark Rotteveel wrote:
::=
TEMPORARY
Using of
::=
[] [TEMPORARY]
won't make a big difference.
Yes it does, this would introduce a semantic ambiguity (and probably a
syntactic ambiguity. In the original syntax, LOCA
23.01.2021 15:42, Adriano dos Santos Fernandes wrote:
If the table metadata is not replicated, there may be problem with
stored routines using it.
Not if "any routine accessing a local table is also local".
We have some spare bits in RDB$RELATIONS.RDB$FLAGS to mark a table as local,
right?
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 rep
23.01.2021 14:20, Mark Rotteveel wrote:
::=
TEMPORARY
Using of
::=
[] [TEMPORARY]
won't make a big difference.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 23-01-2021 12:39, Dimitry Sibiryakov wrote:
23.01.2021 12:35, Dmitry Yemanov wrote:
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
23.01.2021 12:39, Dimitry Sibiryakov wrote:
I would suggest to add syntax "create [local|global] table" which kinda match SQL
standard.
PS: In Avalerion I simply performed such queries in a transaction with "no replication"
flag but Firebird has no such feature.
--
WBR, SD.
Firebird
23.01.2021 12:35, Dmitry Yemanov wrote:
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
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
12 matches
Mail list logo
