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_read is true, federated transactions are processed with REPEATABLE READ isolation level semantics. This is the default.

• When pg_federation_repeatable_read is false, federated transactions are processed with READ COMMITTED isolation level semantics.

For more information, see the following:

• Considerations when accessing federated data with Amazon Redshift.

• Managing concurrent write operations.

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