Thread: pgsql: Prohibit shutting down resources if there is a possibility ofba

Prohibit shutting down resources if there is a possibility of back up.

Currently, we release the asynchronous resources as soon as it is evident
that no more rows will be needed e.g. when a Limit is filled.  This can be
problematic especially for custom and foreign scans where we can scan
backward.  Fix that by disallowing the shutting down of resources in such
cases.

Reported-by: Robert Haas
Analysed-by: Robert Haas and Amit Kapila
Author: Amit Kapila
Reviewed-by: Robert Haas
Backpatch-through: 9.6 where this code was introduced
Discussion: https://postgr.es/m/86137f17-1dfb-42f9-7421-82fd786b04a1@anayrat.info

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/69de17186ad9d668bc0500595b47d9a24def238f

Modified Files
--------------
src/backend/executor/execMain.c  |  8 ++++++--
src/backend/executor/nodeLimit.c | 10 ++++++++--
2 files changed, 14 insertions(+), 4 deletions(-)