Re: Move FOR PORTION OF checks out of analysis - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Move FOR PORTION OF checks out of analysis
Date
Msg-id b43f8b56-86f7-4236-b2bd-223ff0cc359d@eisentraut.org
Whole thread
In response to Re: Move FOR PORTION OF checks out of analysis  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: Move FOR PORTION OF checks out of analysis
List pgsql-hackers
On 24.06.26 18:39, Paul A Jungwirth wrote:
> On Wed, Jun 24, 2026 at 2:54 AM Peter Eisentraut <peter@eisentraut.org> wrote:
>>
>> I have checked the patch v9 0002 "Move FOR PORTION OF volatile check
>> into planner".  Functionality-wise, this seems correct.
>>
>> Could you explain why you used EXPRKIND_TARGET?  Maybe there is a good
>> reason, but otherwise it seems kind of arbitrary.
> 
> This expression is used in the target list to set the application-time
> column. We intersect the old value with the FOR PORTION OF bounds.
> 
>> The new ereport call in planner.c has some funny parentheses: You have
>> parentheses around errmsg, but not around errcode.  This is probably
>> because of the way this was copy and pasted from its previous location.
> 
> Here are new patches with the parens cleaned up.

Ok, I have committed that v10 0002 patch.  I will look at the other one 
next.




pgsql-hackers by date:

Previous
From: Tatsuya Kawata
Date:
Subject: Re: Add per-backend lock statistics
Next
From: Jeff Davis
Date:
Subject: Re: Small patch to improve safety of utf8_to_unicode().