Horton

Re: pgsql_fdw, FDW for PostgreSQL server

Albe Laurenz <laurenz.albe@wien.gv.at>

View thread
From: "Albe Laurenz" <laurenz.albe@wien.gv.at>
To: "Shigeru Hanada *EXTERN*" <shigeru.hanada@gmail.com>
Cc: "Kohei KaiGai" <kaigai@kaigai.gr.jp>, "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>, "Tom Lane" <tgl@sss.pgh.pa.us>, "Robert Haas" <robertmhaas@gmail.com>, "Hitoshi Harada" <umi.tanuki@gmail.com>, "Martijn van Oosterhout" <kleptog@svana.org>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2012-02-17T12:08:47Z
Lists: pgsql-hackers 
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