On 6-11-2014 16:40, Dimitry Sibiryakov wrote:
> Hello, All.
>
> I wonder if SQL standard says something about syntax of transaction's
> option for
> disabling replication of changes made by this transaction?
There is no such option, the syntax is:
<set transaction statement> ::=
SET [ LOCAL ] TRANSACTION <transaction characteristics>
<transaction characteristics> ::=
[ <transaction mode> [ { <comma> <transaction mode> }... ] ]
<transaction mode> ::=
<isolation level>
| <transaction access mode>
| <diagnostics size>
<transaction access mode> ::=
READ ONLY
| READ WRITE
<isolation level> ::=
ISOLATION LEVEL <level of isolation>
<level of isolation> ::=
READ UNCOMMITTED
| READ COMMITTED
| REPEATABLE READ
| SERIALIZABLE
<diagnostics size> ::=
DIAGNOSTICS SIZE <number of conditions>
<number of conditions> ::=
<simple value specification>
I don't really understand why you would want to disable replication for
a single transaction. If that transaction does something like adding a
new record and the next transaction (with replication) inserts a record
that depends on the record then either the replication will fail, or you
now have an inconsistent replica. Neither sounds like a good plan.
Mark
--
Mark Rotteveel
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
