pg_federation_repeatable_read - Amazon Redshift


Values (default in bold)

true, false


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:


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