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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers