pg_federation_repeatable_read
Values (default in bold)
true, false
Description
Specifies the federated query transaction isolation level for the results from the PostgreSQL database.
When
pg_federation_repeatable_readis true, federated transactions are processed with REPEATABLE READ isolation level semantics. This is the default.When
pg_federation_repeatable_readis false, federated transactions are processed with READ COMMITTED isolation level semantics.
For more information, see the following:
Examples
The following command sets pg_federation_repeatable_read to on for a session.
The show command shows the value of the set value.
set pg_federation_repeatable_read to on;
show pg_federation_repeatable_read;
pg_federation_repeatable_read
-----------------------------
on
