Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6ef77cf

Browse files
committed
Further adjust EXPLAIN's choices of table alias names.
This patch causes EXPLAIN to always assign a separate table alias to theparent RTE of an append relation (inheritance set); before, such RTEswere ignored if not actually scanned by the plan. Since the child RTEsnow always have that same alias to start with (cf. commit55a1954),the net effect is that the parent RTE usually gets the alias used orimplied by the query text, and the children all get that alias with "_N"appended. (The exception to "usually" is if there are duplicate aliasesin different subtrees of the original query; then some of those originalRTEs will also have "_N" appended.)This results in more uniform output for partitioned-table plans thanwe had before: the partitioned table itself gets the original alias,and all child tables have aliases with "_N", rather than the previousbehavior where one of the children would get an alias without "_N".The reason for giving the parent RTE an alias, even if it isn't scannedby the plan, is that we now use the parent's alias to qualify Vars thatrefer to an appendrel output column and appear above the Append orMergeAppend that computes the appendrel. But below the append, Varsrefer to some one of the child relations, and are displayed that way.This seems clearer than the old behavior where a Var that could carryvalues from any child relation was displayed as if it referred to onlyone of them.While at it, change ruleutils.c so that the code paths used by EXPLAINdeal in Plan trees not PlanState trees. This effectively reverts adecision made in commit1cc29fe, which seemed like a good idea atthe time to make ruleutils.c consistent with explain.c. However,it's problematic because we'd really like to allow executor startuppruning to remove all the children of an append node when possible,leaving no child PlanState to resolve Vars against. (That's not donehere, but will be in the next patch.) This requires different handlingof subplans and initplans than before, but is otherwise a prettystraightforward change.Discussion:https://postgr.es/m/001001d4f44b$2a2cca50$7e865ef0$@lab.ntt.co.jp
1 parentba79cb5 commit6ef77cf

26 files changed

+1936
-1732
lines changed

‎contrib/postgres_fdw/expected/postgres_fdw.out

Lines changed: 45 additions & 45 deletions
Original file line numberDiff line numberDiff line change
@@ -7094,21 +7094,21 @@ select * from bar where f1 in (select f1 from foo) for update;
70947094
Inner Unique: true
70957095
Hash Cond: (bar.f1 = foo.f1)
70967096
-> Append
7097-
-> Seq Scan on public.bar
7098-
Output: bar.f1, bar.f2, bar.ctid, bar.*, bar.tableoid
7099-
-> Foreign Scan on public.bar2 bar_1
7097+
-> Seq Scan on public.bar bar_1
71007098
Output: bar_1.f1, bar_1.f2, bar_1.ctid, bar_1.*, bar_1.tableoid
7099+
-> Foreign Scan on public.bar2 bar_2
7100+
Output: bar_2.f1, bar_2.f2, bar_2.ctid, bar_2.*, bar_2.tableoid
71017101
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct2 FOR UPDATE
71027102
-> Hash
71037103
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71047104
-> HashAggregate
71057105
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71067106
Group Key: foo.f1
71077107
-> Append
7108-
-> Seq Scan on public.foo
7109-
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
7110-
-> Foreign Scan on public.foo2 foo_1
7108+
-> Seq Scan on public.foo foo_1
71117109
Output: foo_1.ctid, foo_1.f1, foo_1.*, foo_1.tableoid
7110+
-> Foreign Scan on public.foo2 foo_2
7111+
Output: foo_2.ctid, foo_2.f1, foo_2.*, foo_2.tableoid
71127112
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1
71137113
(23 rows)
71147114

@@ -7132,21 +7132,21 @@ select * from bar where f1 in (select f1 from foo) for share;
71327132
Inner Unique: true
71337133
Hash Cond: (bar.f1 = foo.f1)
71347134
-> Append
7135-
-> Seq Scan on public.bar
7136-
Output: bar.f1, bar.f2, bar.ctid, bar.*, bar.tableoid
7137-
-> Foreign Scan on public.bar2 bar_1
7135+
-> Seq Scan on public.bar bar_1
71387136
Output: bar_1.f1, bar_1.f2, bar_1.ctid, bar_1.*, bar_1.tableoid
7137+
-> Foreign Scan on public.bar2 bar_2
7138+
Output: bar_2.f1, bar_2.f2, bar_2.ctid, bar_2.*, bar_2.tableoid
71397139
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct2 FOR SHARE
71407140
-> Hash
71417141
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71427142
-> HashAggregate
71437143
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71447144
Group Key: foo.f1
71457145
-> Append
7146-
-> Seq Scan on public.foo
7147-
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
7148-
-> Foreign Scan on public.foo2 foo_1
7146+
-> Seq Scan on public.foo foo_1
71497147
Output: foo_1.ctid, foo_1.f1, foo_1.*, foo_1.tableoid
7148+
-> Foreign Scan on public.foo2 foo_2
7149+
Output: foo_2.ctid, foo_2.f1, foo_2.*, foo_2.tableoid
71507150
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1
71517151
(23 rows)
71527152

@@ -7180,10 +7180,10 @@ update bar set f2 = f2 + 100 where f1 in (select f1 from foo);
71807180
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71817181
Group Key: foo.f1
71827182
-> Append
7183-
-> Seq Scan on public.foo
7184-
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
7185-
-> Foreign Scan on public.foo2 foo_1
7183+
-> Seq Scan on public.foo foo_1
71867184
Output: foo_1.ctid, foo_1.f1, foo_1.*, foo_1.tableoid
7185+
-> Foreign Scan on public.foo2 foo_2
7186+
Output: foo_2.ctid, foo_2.f1, foo_2.*, foo_2.tableoid
71877187
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1
71887188
-> Hash Join
71897189
Output: bar_1.f1, (bar_1.f2 + 100), bar_1.f3, bar_1.ctid, foo.ctid, foo.*, foo.tableoid
@@ -7198,10 +7198,10 @@ update bar set f2 = f2 + 100 where f1 in (select f1 from foo);
71987198
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
71997199
Group Key: foo.f1
72007200
-> Append
7201-
-> Seq Scan on public.foo
7202-
Output: foo.ctid, foo.f1, foo.*, foo.tableoid
7203-
-> Foreign Scan on public.foo2 foo_1
7201+
-> Seq Scan on public.foo foo_1
72047202
Output: foo_1.ctid, foo_1.f1, foo_1.*, foo_1.tableoid
7203+
-> Foreign Scan on public.foo2 foo_2
7204+
Output: foo_2.ctid, foo_2.f1, foo_2.*, foo_2.tableoid
72057205
Remote SQL: SELECT f1, f2, f3, ctid FROM public.loct1
72067206
(39 rows)
72077207

@@ -7316,10 +7316,10 @@ explain (verbose, costs off)
73167316
Merge Cond: (foo.f1 = loct1.f1)
73177317
-> Merge Append
73187318
Sort Key: foo.f1
7319-
-> Index Scan using i_foo_f1 on public.foo
7320-
Output: foo.f1, foo.f2
7321-
-> Foreign Scan on public.foo2 foo_1
7319+
-> Index Scan using i_foo_f1 on public.foo foo_1
73227320
Output: foo_1.f1, foo_1.f2
7321+
-> Foreign Scan on public.foo2 foo_2
7322+
Output: foo_2.f1, foo_2.f2
73237323
Remote SQL: SELECT f1, f2 FROM public.loct1 ORDER BY f1 ASC NULLS LAST
73247324
-> Index Only Scan using i_loct1_f1 on public.loct1
73257325
Output: loct1.f1
@@ -7356,10 +7356,10 @@ explain (verbose, costs off)
73567356
Merge Cond: (foo.f1 = loct1.f1)
73577357
-> Merge Append
73587358
Sort Key: foo.f1
7359-
-> Index Scan using i_foo_f1 on public.foo
7360-
Output: foo.f1, foo.f2
7361-
-> Foreign Scan on public.foo2 foo_1
7359+
-> Index Scan using i_foo_f1 on public.foo foo_1
73627360
Output: foo_1.f1, foo_1.f2
7361+
-> Foreign Scan on public.foo2 foo_2
7362+
Output: foo_2.f1, foo_2.f2
73637363
Remote SQL: SELECT f1, f2 FROM public.loct1 ORDER BY f1 ASC NULLS LAST
73647364
-> Index Only Scan using i_loct1_f1 on public.loct1
73657365
Output: loct1.f1
@@ -8516,9 +8516,9 @@ SELECT t1.a,t2.b,t3.c FROM fprt1 t1 INNER JOIN fprt2 t2 ON (t1.a = t2.b) INNER J
85168516
Sort Key: t1.a, t3.c
85178517
-> Append
85188518
-> Foreign Scan
8519-
Relations: ((ftprt1_p1t1) INNER JOIN (ftprt2_p1t2)) INNER JOIN (ftprt1_p1t3)
8519+
Relations: ((ftprt1_p1t1_1) INNER JOIN (ftprt2_p1t2_1)) INNER JOIN (ftprt1_p1t3_1)
85208520
-> Foreign Scan
8521-
Relations: ((ftprt1_p2t1_1) INNER JOIN (ftprt2_p2t2_1)) INNER JOIN (ftprt1_p2t3_1)
8521+
Relations: ((ftprt1_p2t1_2) INNER JOIN (ftprt2_p2t2_2)) INNER JOIN (ftprt1_p2t3_2)
85228522
(7 rows)
85238523

85248524
SELECT t1.a,t2.b,t3.c FROM fprt1 t1 INNER JOIN fprt2 t2 ON (t1.a = t2.b) INNER JOIN fprt1 t3 ON (t2.b = t3.a) WHERE t1.a % 25 =0 ORDER BY 1,2,3;
@@ -8561,12 +8561,12 @@ SELECT t1.wr, t2.wr FROM (SELECT t1 wr, a FROM fprt1 t1 WHERE t1.a % 25 = 0) t1
85618561
-> Hash Full Join
85628562
Hash Cond: (t1.a = t2.b)
85638563
-> Append
8564-
-> Foreign Scan on ftprt1_p1t1
8565-
-> Foreign Scan on ftprt1_p2t1_1
8564+
-> Foreign Scan on ftprt1_p1t1_1
8565+
-> Foreign Scan on ftprt1_p2t1_2
85668566
-> Hash
85678567
-> Append
8568-
-> Foreign Scan on ftprt2_p1t2
8569-
-> Foreign Scan on ftprt2_p2t2_1
8568+
-> Foreign Scan on ftprt2_p1t2_1
8569+
-> Foreign Scan on ftprt2_p2t2_2
85708570
(11 rows)
85718571

85728572
SELECT t1.wr, t2.wr FROM (SELECT t1 wr, a FROM fprt1 t1 WHERE t1.a % 25 = 0) t1 FULL JOIN (SELECT t2 wr, b FROM fprt2 t2 WHERE t2.b % 25 = 0) t2 ON (t1.a = t2.b) ORDER BY 1,2;
@@ -8597,9 +8597,9 @@ SELECT t1.a,t1.b FROM fprt1 t1, LATERAL (SELECT t2.a, t2.b FROM fprt2 t2 WHERE t
85978597
Sort Key: t1.a, t1.b
85988598
-> Append
85998599
-> Foreign Scan
8600-
Relations: (ftprt1_p1t1) INNER JOIN (ftprt2_p1t2)
8600+
Relations: (ftprt1_p1t1_1) INNER JOIN (ftprt2_p1t2_1)
86018601
-> Foreign Scan
8602-
Relations: (ftprt1_p2t1_1) INNER JOIN (ftprt2_p2t2_1)
8602+
Relations: (ftprt1_p2t1_2) INNER JOIN (ftprt2_p2t2_2)
86038603
(7 rows)
86048604

86058605
SELECT t1.a,t1.b FROM fprt1 t1, LATERAL (SELECT t2.a, t2.b FROM fprt2 t2 WHERE t1.a = t2.b AND t1.b = t2.a) q WHERE t1.a%25 = 0 ORDER BY 1,2;
@@ -8620,15 +8620,15 @@ SELECT t1.a, t1.phv, t2.b, t2.phv FROM (SELECT 't1_phv' phv, * FROM fprt1 WHERE
86208620
Sort Key: fprt1.a, fprt2.b
86218621
-> Append
86228622
-> Hash Full Join
8623-
Hash Cond: (fprt1.a =fprt2.b)
8624-
-> Foreign Scan on ftprt1_p1fprt1
8623+
Hash Cond: (fprt1_1.a =fprt2_1.b)
8624+
-> Foreign Scan on ftprt1_p1fprt1_1
86258625
-> Hash
8626-
-> Foreign Scan on ftprt2_p1fprt2
8626+
-> Foreign Scan on ftprt2_p1fprt2_1
86278627
-> Hash Full Join
8628-
Hash Cond: (fprt1_1.a =fprt2_1.b)
8629-
-> Foreign Scan on ftprt1_p2fprt1_1
8628+
Hash Cond: (fprt1_2.a =fprt2_2.b)
8629+
-> Foreign Scan on ftprt1_p2fprt1_2
86308630
-> Hash
8631-
-> Foreign Scan on ftprt2_p2fprt2_1
8631+
-> Foreign Scan on ftprt2_p2fprt2_2
86328632
(13 rows)
86338633

86348634
SELECT t1.a, t1.phv, t2.b, t2.phv FROM (SELECT 't1_phv' phv, * FROM fprt1 WHERE a % 25 = 0) t1 FULL JOIN (SELECT 't2_phv' phv, * FROM fprt2 WHERE b % 25 = 0) t2 ON (t1.a = t2.b) ORDER BY t1.a, t2.b;
@@ -8661,12 +8661,12 @@ SELECT t1.a, t2.b FROM fprt1 t1 INNER JOIN fprt2 t2 ON (t1.a = t2.b) WHERE t1.a
86618661
-> Hash Join
86628662
Hash Cond: (t2.b = t1.a)
86638663
-> Append
8664-
-> Foreign Scan on ftprt2_p1t2
8665-
-> Foreign Scan on ftprt2_p2t2_1
8664+
-> Foreign Scan on ftprt2_p1t2_1
8665+
-> Foreign Scan on ftprt2_p2t2_2
86668666
-> Hash
86678667
-> Append
8668-
-> Foreign Scan on ftprt1_p1t1
8669-
-> Foreign Scan on ftprt1_p2t1_1
8668+
-> Foreign Scan on ftprt1_p1t1_1
8669+
-> Foreign Scan on ftprt1_p2t1_2
86708670
(12 rows)
86718671

86728672
SELECT t1.a, t2.b FROM fprt1 t1 INNER JOIN fprt2 t2 ON (t1.a = t2.b) WHERE t1.a % 25 = 0 ORDER BY 1,2 FOR UPDATE OF t1;
@@ -8710,9 +8710,9 @@ SELECT a, sum(b), min(b), count(*) FROM pagg_tab GROUP BY a HAVING avg(b) < 22 O
87108710
Group Key: pagg_tab.a
87118711
Filter: (avg(pagg_tab.b) < '22'::numeric)
87128712
-> Append
8713-
-> Foreign Scan on fpagg_tab_p1pagg_tab
8714-
-> Foreign Scan on fpagg_tab_p2pagg_tab_1
8715-
-> Foreign Scan on fpagg_tab_p3pagg_tab_2
8713+
-> Foreign Scan on fpagg_tab_p1pagg_tab_1
8714+
-> Foreign Scan on fpagg_tab_p2pagg_tab_2
8715+
-> Foreign Scan on fpagg_tab_p3pagg_tab_3
87168716
(9 rows)
87178717

87188718
-- Plan with partitionwise aggregates is enabled

‎src/backend/commands/explain.c

Lines changed: 41 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -689,8 +689,8 @@ ExplainPrintPlan(ExplainState *es, QueryDesc *queryDesc)
689689
es->rtable=queryDesc->plannedstmt->rtable;
690690
ExplainPreScanNode(queryDesc->planstate,&rels_used);
691691
es->rtable_names=select_rtable_names_for_explain(es->rtable,rels_used);
692-
es->deparse_cxt=deparse_context_for_plan_rtable(es->rtable,
693-
es->rtable_names);
692+
es->deparse_cxt=deparse_context_for_plan_tree(queryDesc->plannedstmt,
693+
es->rtable_names);
694694
es->printed_subplans=NULL;
695695

696696
/*
@@ -1034,6 +1034,14 @@ ExplainPreScanNode(PlanState *planstate, Bitmapset **rels_used)
10341034
*rels_used=bms_add_member(*rels_used,
10351035
((ModifyTable*)plan)->exclRelRTI);
10361036
break;
1037+
caseT_Append:
1038+
*rels_used=bms_add_members(*rels_used,
1039+
((Append*)plan)->apprelids);
1040+
break;
1041+
caseT_MergeAppend:
1042+
*rels_used=bms_add_members(*rels_used,
1043+
((MergeAppend*)plan)->apprelids);
1044+
break;
10371045
default:
10381046
break;
10391047
}
@@ -1049,8 +1057,8 @@ ExplainPreScanNode(PlanState *planstate, Bitmapset **rels_used)
10491057
* We need to work from a PlanState node, not just a Plan node, in order to
10501058
* get at the instrumentation data (if any) as well as the list of subplans.
10511059
*
1052-
* ancestors is a list of parentPlanStatenodes, most-closely-nested first.
1053-
* These are needed in order to interpret PARAM_EXEC Params.
1060+
* ancestors is a list of parentPlan and SubPlannodes, most-closely-nested
1061+
*first.These are needed in order to interpret PARAM_EXEC Params.
10541062
*
10551063
* relationship describes the relationship of this plan node to its parent
10561064
* (eg, "Outer", "Inner"); it can be null at top level. plan_name is an
@@ -1953,8 +1961,8 @@ ExplainNode(PlanState *planstate, List *ancestors,
19531961
if (haschildren)
19541962
{
19551963
ExplainOpenGroup("Plans","Plans", false,es);
1956-
/* Pass currentPlanState as head of ancestors list for children */
1957-
ancestors=lcons(planstate,ancestors);
1964+
/* Pass currentPlan as head of ancestors list for children */
1965+
ancestors=lcons(plan,ancestors);
19581966
}
19591967

19601968
/* initPlan-s */
@@ -2075,9 +2083,9 @@ show_plan_tlist(PlanState *planstate, List *ancestors, ExplainState *es)
20752083
return;
20762084

20772085
/* Set up deparsing context */
2078-
context=set_deparse_context_planstate(es->deparse_cxt,
2079-
(Node*)planstate,
2080-
ancestors);
2086+
context=set_deparse_context_plan(es->deparse_cxt,
2087+
plan,
2088+
ancestors);
20812089
useprefix=list_length(es->rtable)>1;
20822090

20832091
/* Deparse each result column (we now include resjunk ones) */
@@ -2106,9 +2114,9 @@ show_expression(Node *node, const char *qlabel,
21062114
char*exprstr;
21072115

21082116
/* Set up deparsing context */
2109-
context=set_deparse_context_planstate(es->deparse_cxt,
2110-
(Node*)planstate,
2111-
ancestors);
2117+
context=set_deparse_context_plan(es->deparse_cxt,
2118+
planstate->plan,
2119+
ancestors);
21122120

21132121
/* Deparse the expression */
21142122
exprstr=deparse_expression(node,context,useprefix, false);
@@ -2209,7 +2217,7 @@ show_agg_keys(AggState *astate, List *ancestors,
22092217
if (plan->numCols>0||plan->groupingSets)
22102218
{
22112219
/* The key columns refer to the tlist of the child plan */
2212-
ancestors=lcons(astate,ancestors);
2220+
ancestors=lcons(plan,ancestors);
22132221

22142222
if (plan->groupingSets)
22152223
show_grouping_sets(outerPlanState(astate),plan,ancestors,es);
@@ -2232,9 +2240,9 @@ show_grouping_sets(PlanState *planstate, Agg *agg,
22322240
ListCell*lc;
22332241

22342242
/* Set up deparsing context */
2235-
context=set_deparse_context_planstate(es->deparse_cxt,
2236-
(Node*)planstate,
2237-
ancestors);
2243+
context=set_deparse_context_plan(es->deparse_cxt,
2244+
planstate->plan,
2245+
ancestors);
22382246
useprefix= (list_length(es->rtable)>1||es->verbose);
22392247

22402248
ExplainOpenGroup("Grouping Sets","Grouping Sets", false,es);
@@ -2339,7 +2347,7 @@ show_group_keys(GroupState *gstate, List *ancestors,
23392347
Group*plan= (Group*)gstate->ss.ps.plan;
23402348

23412349
/* The key columns refer to the tlist of the child plan */
2342-
ancestors=lcons(gstate,ancestors);
2350+
ancestors=lcons(plan,ancestors);
23432351
show_sort_group_keys(outerPlanState(gstate),"Group Key",
23442352
plan->numCols,plan->grpColIdx,
23452353
NULL,NULL,NULL,
@@ -2371,9 +2379,9 @@ show_sort_group_keys(PlanState *planstate, const char *qlabel,
23712379
initStringInfo(&sortkeybuf);
23722380

23732381
/* Set up deparsing context */
2374-
context=set_deparse_context_planstate(es->deparse_cxt,
2375-
(Node*)planstate,
2376-
ancestors);
2382+
context=set_deparse_context_plan(es->deparse_cxt,
2383+
plan,
2384+
ancestors);
23772385
useprefix= (list_length(es->rtable)>1||es->verbose);
23782386

23792387
for (keyno=0;keyno<nkeys;keyno++)
@@ -2479,9 +2487,9 @@ show_tablesample(TableSampleClause *tsc, PlanState *planstate,
24792487
ListCell*lc;
24802488

24812489
/* Set up deparsing context */
2482-
context=set_deparse_context_planstate(es->deparse_cxt,
2483-
(Node*)planstate,
2484-
ancestors);
2490+
context=set_deparse_context_plan(es->deparse_cxt,
2491+
planstate->plan,
2492+
ancestors);
24852493
useprefix=list_length(es->rtable)>1;
24862494

24872495
/* Get the tablesample method name */
@@ -3344,7 +3352,7 @@ ExplainMemberNodes(PlanState **planstates, int nsubnodes, int nplans,
33443352
* Explain a list of SubPlans (or initPlans, which also use SubPlan nodes).
33453353
*
33463354
* The ancestors list should already contain the immediate parent of these
3347-
*SubPlanStates.
3355+
*SubPlans.
33483356
*/
33493357
staticvoid
33503358
ExplainSubPlans(List*plans,List*ancestors,
@@ -3372,8 +3380,17 @@ ExplainSubPlans(List *plans, List *ancestors,
33723380
es->printed_subplans=bms_add_member(es->printed_subplans,
33733381
sp->plan_id);
33743382

3383+
/*
3384+
* Treat the SubPlan node as an ancestor of the plan node(s) within
3385+
* it, so that ruleutils.c can find the referents of subplan
3386+
* parameters.
3387+
*/
3388+
ancestors=lcons(sp,ancestors);
3389+
33753390
ExplainNode(sps->planstate,ancestors,
33763391
relationship,sp->plan_name,es);
3392+
3393+
ancestors=list_delete_first(ancestors);
33773394
}
33783395
}
33793396

‎src/backend/executor/execParallel.c

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -181,6 +181,8 @@ ExecSerializePlan(Plan *plan, EState *estate)
181181
pstmt->planTree=plan;
182182
pstmt->rtable=estate->es_range_table;
183183
pstmt->resultRelations=NIL;
184+
pstmt->rootResultRelations=NIL;
185+
pstmt->appendRelations=NIL;
184186

185187
/*
186188
* Transfer only parallel-safe subplans, leaving a NULL "hole" in the list

‎src/backend/executor/nodeModifyTable.c

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2526,9 +2526,6 @@ ExecInitModifyTable(ModifyTable *node, EState *estate, int eflags)
25262526
econtext=mtstate->ps.ps_ExprContext;
25272527
relationDesc=resultRelInfo->ri_RelationDesc->rd_att;
25282528

2529-
/* carried forward solely for the benefit of explain */
2530-
mtstate->mt_excludedtlist=node->exclRelTlist;
2531-
25322529
/* create state for DO UPDATE SET operation */
25332530
resultRelInfo->ri_onConflict=makeNode(OnConflictSetState);
25342531

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp