Re: [HACKERS] Useless code in ExecInitModifyTable - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: [HACKERS] Useless code in ExecInitModifyTable
Date
Msg-id 9bf5c92a-5501-d1e4-dafc-1f2558f42693@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] Useless code in ExecInitModifyTable  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: [HACKERS] Useless code in ExecInitModifyTable  (Ryan Murphy <ryanfmurphy@gmail.com>)
List pgsql-hackers
On 2017/06/21 17:57, Amit Langote wrote:
> On 2017/06/21 16:59, Etsuro Fujita wrote:
>> Commit d3cc37f1d801a6b5cad9bf179274a8d767f1ee50 added this to
>> ExecInitModifyTable:
>>
>> +   /* The root table RT index is at the head of the partitioned_rels list */
>> +   if (node->partitioned_rels)
>> +   {
>> +       Index   root_rti;
>> +       Oid     root_oid;
>> +
>> +       root_rti = linitial_int(node->partitioned_rels);
>> +       root_oid = getrelid(root_rti, estate->es_range_table);
>> +       rel = heap_open(root_oid, NoLock);  /* locked by InitPlan */
>> +   }
>>
>> but I noticed that that function doesn't use the relation descriptor at
>> all.  Since partitioned_rels is given in case of an UPDATE/DELETE on a
>> partitioned table, the relation is opened in that case, but the relation
>> descriptor isn't referenced at all in initializing WITH CHECK OPTION
>> constraints and/or RETURNING projections.  (The mtstate->resultRelinfo
>> array is referenced in those initialization, instead.)  So, I'd like to
>> propose to remove this from that function.  Attached is a patch for that.
> 
> Thanks for cleaning that up.  I cannot see any problem in applying the patch.

I noticed that the patch needs to be rebased.  Updated patch attached.

Thanks for the review!

Best regards,
Etsuro Fujita

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] pgsql: pg_rewind: Fix some problemswhen copying files >2GB.
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] dropping partitioned tables without CASCADE