| From: | Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
| Subject: | Re: pgsql_fdw, FDW for PostgreSQL server |
| Date: | 2012-02-23 05:14:07 |
| Message-ID: | 4F45CB1F.2030201@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
(2012/02/21 8:07), Shigeru Hanada wrote:
> Hm, agreed that isolation levels< REPEATABLE READ are not sufficient for
> pgsql_fdw's usage. I'll examine the example and fix pgsql_fdw.
Attached patch uses "safe" isolation level for remote transactions.
After this change, pgsql_fdw uses levels below:
local | remote
------------------+-----------------
SERIALIZABLE | SERIALIZABLE
REPEATABLE READ | REPEATABLE READ
READ COMMITTED | REPEATABLE READ
READ UNCOMMITTED | REPEATABLE READ
Please review document of pgsql_fdw too.
In addition, I've removed #ifdef from options.c, so that we can specify
libpq options about SSL and Kerberos even if such feature has not been
configured on the environment where pgsql_fdw was built. This change
also avoids regression test failure on environment where any of
--with-openssl or --with-krb5 was specified for configure script.
Regards,
--
Shigeru Hanada
| Attachment | Content-Type | Size |
|---|---|---|
| pgsql_fdw_v12.patch | text/plain | 108.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gianni Ciolli | 2012-02-23 07:15:28 | Re: Triggers with DO functionality |
| Previous Message | Daniel Farina | 2012-02-23 04:17:08 | Re: Should we add crc32 in libpgport? |