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: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>, "Tom Lane" <tgl@sss.pgh.pa.us>, "Robert Haas" <robertmhaas@gmail.com>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>, "Kohei KaiGai" <kaigai@kaigai.gr.jp>, "Martijn van Oosterhout" <kleptog@svana.org>, "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>, "Hitoshi Harada" <umi.tanuki@gmail.com>
Date: 2012-03-06T14:47:39Z
Lists: pgsql-hackers 
Shigeru Hanada wrote:
>                Connection should be closed only when the trigger is a
> top level transaction and it's aborting, but isTopLevel flag was not
> checked.  I fixed the bug and added regression tests for such cases.

I wondered about that - is it really necessary to close the remote
connection? Wouldn't a ROLLBACK on the remote connection be good enough?

Yours,
Laurenz Albe