]> granicus.if.org Git - postgresql/commit
Fix handling of volatile expressions in COPY FROM ... WHERE
authorTomas Vondra <tomas.vondra@postgresql.org>
Tue, 22 Jan 2019 22:11:17 +0000 (23:11 +0100)
committerTomas Vondra <tomas.vondra@postgresql.org>
Tue, 22 Jan 2019 22:11:17 +0000 (23:11 +0100)
commit4a8283d0ec5a6781b9e0d4ba16b44da8a0856d02
tree2ee96ab66a882847fae278d001930af5a6033bc2
parent005881033d4e34c0b2e0a157464dc1929db52e17
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
src/backend/commands/copy.c