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
> multiple queries are executed in a remote transaction. So IMO
> levels are useful even if remote query is executed only once.
Oh, I see. You are right.
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2012-02-17 12:53:39|
|Subject: Re: MySQL search query is not executing in Postgres DB|
|Previous:||From: Fujii Masao||Date: 2012-02-17 10:04:39|
|Subject: Re: Displaying accumulated autovacuum cost|