Re: postgres_fdw: incomplete subabort cleanup of connections used in async execution

Alexander Pyhalov <a.pyhalov@postgrespro.ru>

From: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-12-21T16:08:26Z
Lists: pgsql-hackers
Etsuro Fujita писал 2021-12-19 13:25:
> Hi,
> 
> While working on [1], I noticed $SUBJECT: postgres_fdw resets the
> per-connection states of connections, which store async requests sent
> to remote servers in async_capable mode, during post-abort
> (pgfdw_xact_callback()), but it fails to do so during post-subabort
> (pgfdw_subxact_callback()).  This causes a crash when re-executing a
> query that was aborted in a subtransaction:
> 

Hi.
Looks good to me.
-- 
Best regards,
Alexander Pyhalov,
Postgres Professional



Commits

  1. postgres_fdw: Fix subabort cleanup of connections used in asynchronous execution.

  2. Add support for asynchronous execution.