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

From Stephen Frost
Subject Re: [HACKERS] Useless code in ExecInitModifyTable
Date
Msg-id 20180115022818.GF2416@tamriel.snowman.net
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
List pgsql-hackers
Fujita-san, Amit,

* Amit Langote (Langote_Amit_f8@lab.ntt.co.jp) 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.

Seems like this has gotten a review (and quite a bit of down-stream
discussion that seemed pretty positive), and the latest patch still
applies cleanly and passes the regression tests- is there some reason
it's still marked as Needs Review?  Seems like it should really be in
Ready for Committer state.

Amit, if you agree, would you mind going ahead and changing it?

Thanks!

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Removing WITH clause support in CREATE FUNCTION, for isCachable andisStrict
Next
From: Stephen Frost
Date:
Subject: Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patchfor hash index