Re: COPY FROM WHEN condition - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: COPY FROM WHEN condition
Date
Msg-id 6e80b7c1-58cd-4212-41d3-7c519aed0500@2ndquadrant.com
Whole thread Raw
In response to Re: COPY FROM WHEN condition  (Andres Freund <andres@anarazel.de>)
Responses Re: COPY FROM WHEN condition  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers

On 1/20/19 8:24 PM, Andres Freund wrote:
> Hi,
> 
> On 2019-01-20 00:24:05 +0100, Tomas Vondra wrote:
>> 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.
> 
> While rebasing the pluggable storage patch ontop of this I noticed that
> the qual appears to be evaluated in query context. Isn't that a bad
> idea? ISMT it should have been evaluated a few lines above, before the:
> 
>         /* Triggers and stuff need to be invoked in query context. */
>         MemoryContextSwitchTo(oldcontext);
> 
> Yes, that'd require moving the ExecStoreHeapTuple(), but that seems ok?
> 

Yes, I agree. It's a bit too late for me to hack and push stuff, but 
I'll fix that tomorrow.

cheers

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] pgbench tap tests fail if the path contains a perl special character
Next
From: Andres Freund
Date:
Subject: Re: COPY FROM WHEN condition