Shigeru Hanada wrote:
>> - Since a rescan is done by rewinding the cursor, is it necessary
>> to have any other remote isolation level than READ COMMITED?
>> There is only one query issued per transaction.
>
> If multiple foreign tables on a foreign server is used in a local
query,
> multiple queries are executed in a remote transaction. So IMO
isolation
> levels are useful even if remote query is executed only once.
Oh, I see. You are right.
Yours,
Laurenz Albe