Subject: Re: COPY FROM WHEN condition
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Surafel Temesgen <surafel3000@gmail.com>
Cc: alvherre@2ndquadrant.com, Adam Berlin <berlin.ab@gmail.com>,
 pgsql-hackers@lists.postgresql.org
References: <194e2225-b186-9325-0cd1-9a5b09d28251@2ndquadrant.com>
 <20181204094418.wpr6mxrtsuxb5mlq@alvherre.pgsql>
 <CALAY4q_Ej0QyQJOXMdMF6i9ufBnDfJP0DRhm910F4Qm5AV5xUw@mail.gmail.com>
 <3b2b1aac-5861-acd8-fda3-054c4e4da888@2ndquadrant.com>
 <CALAY4q-6ffQPi+CZMVjddEMXe_QBrqfz6aauc+QPxSLEO9vUQQ@mail.gmail.com>
 <b5234b76-9ee0-6a44-6a21-d90c385a27b8@2ndquadrant.com>
Message-ID: <ea03bbf3-c201-5ce1-eee9-9fc4b527fd03@2ndquadrant.com>
Date: Sun, 20 Jan 2019 00:24:05 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.3.1
MIME-Version: 1.0
In-Reply-To: <b5234b76-9ee0-6a44-6a21-d90c385a27b8@2ndquadrant.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk


On 1/14/19 10:25 PM, Tomas Vondra wrote:
> On 12/13/18 8:09 AM, Surafel Temesgen wrote:
>>
>>
>> On Wed, Dec 12, 2018 at 9:28 PM Tomas Vondra
>> <tomas.vondra@2ndquadrant.com <mailto:tomas.vondra@2ndquadrant.com>> wrote:
>>
>>
>>     Can you also update the docs to mention that the functions called from
>>     the WHERE clause does not see effects of the COPY itself?
>>
>>
>> /Of course, i  also add same comment to insertion method selection
>> /
> 
> FWIW I've marked this as RFC and plan to get it committed this week.
> 

Pushed, thanks for the patch.

cheers

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services