pgsql: Fix handling of volatile expressions in COPY FROM ... WHERE - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Fix handling of volatile expressions in COPY FROM ... WHERE
Date
Msg-id E1gm54o-0007zC-Ai@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix handling of volatile expressions in COPY FROM ... WHERE

The checking for calls to volatile functions in the COPY FROM ... WHERE
expression was treating all WHERE clauses as if containing such calls.
While that does not produce incorrect results, this disables batching
which may result in significant performance regression.

Discussion:
https://www.postgresql.org/message-id/flat/CALAY4q_DdpWDuB5-Zyi-oTtO2uSk8pmy+dupiRe3AvAc++1imA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4a8283d0ec5a6781b9e0d4ba16b44da8a0856d02

Modified Files
--------------
src/backend/commands/copy.c | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: llvm: Fix file-ending in IDENTIFICATION comments.
Next
From: Michael Paquier
Date:
Subject: pgsql: Make vacuumdb test regex more modular for its query output