Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# pg\$1federation\$1repeatable\$1read
<a name="r_pg_federation_repeatable_read"></a>

## Values (default in bold)
<a name="pg_federation_repeatable_read-values"></a>

**true**, *false*

## Description
<a name="description"></a>

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](federated-limitations.md).
+ [Managing concurrent write operations](c_Concurrent_writes.md).

## Examples
<a name="pg_federation_repeatable_read-example"></a>

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
```