postgres

History

Etsuro Fujita af8f9248fb postgres_fdw: Fix handling of abort-cleanup-failed connections. As connections that failed abort cleanup can't safely be further used, if a remote query tries to get such a connection, we reject it. Previously, this rejection involved dropping the connection if it was open, without accounting for the possibility of open cursors using it, causing a server crash when such an open cursor tried to use an already-dropped connection, as a cursor-handling function (create_cursor, fetch_more_data, or close_cursor) was called on a freed PGconn. To fix, delay dropping failed connections until abort cleanup of the main transaction, to ensure open cursors using such a connection can safely refer to the PGconn for it. Oversight in commit `8bf58c0d9`. Reported-by: Zhibai Song <songzhibai1234@gmail.com> Diagnosed-by: Zhibai Song <songzhibai1234@gmail.com> Author: Etsuro Fujita <etsuro.fujita@gmail.com> Reviewed-by: Michael Paquier <michael@paquier.xyz> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Matheus Alcantara <matheusssilv97@gmail.com> Discussion: https://postgr.es/m/CAPmGK176y6JP017-Cn%2BhS9CEJx_6iVhRoYbAqzuLU4d8-XPPNg%40mail.gmail.com Backpatch-through: 14		1 month ago
..
expected	postgres_fdw: Fix handling of abort-cleanup-failed connections.	1 month ago
specs	postgres_fdw: Add more test coverage for EvalPlanQual testing.	7 months ago
sql	postgres_fdw: Fix handling of abort-cleanup-failed connections.	1 month ago
.gitignore	Fix EvalPlanQual handling of foreign/custom joins in ExecScanFetch.	8 months ago
Makefile	Fix EvalPlanQual handling of foreign/custom joins in ExecScanFetch.	8 months ago
connection.c	postgres_fdw: Fix handling of abort-cleanup-failed connections.	1 month ago
deparse.c	…
meson.build	Fix EvalPlanQual handling of foreign/custom joins in ExecScanFetch.	8 months ago
option.c	…
postgres_fdw--1.0--1.1.sql	…
postgres_fdw--1.0.sql	…
postgres_fdw.c	…
postgres_fdw.control	…
postgres_fdw.h	…
shippable.c	…