DROP TABLE parent_tbl CASCADE;

NOTICE: drop cascades to view rw_view

DROP FUNCTION row_before_insupd_trigfunc;

-- Try a more complex permutation of WCO where there are multiple levels of

-- partitioned tables with columns not all in the same order

CREATE TABLE parent_tbl (a int, b text, c numeric) PARTITION BY RANGE(a);

CREATE TABLE sub_parent (c numeric, a int, b text) PARTITION BY RANGE(a);

ALTER TABLE parent_tbl ATTACH PARTITION sub_parent FOR VALUES FROM (1) TO (10);

CREATE TABLE child_local (b text, c numeric, a int);

CREATE FOREIGN TABLE child_foreign (b text, c numeric, a int)

SERVER loopback OPTIONS (table_name 'child_local');

ALTER TABLE sub_parent ATTACH PARTITION child_foreign FOR VALUES FROM (1) TO (10);

CREATE VIEW rw_view AS SELECT * FROM parent_tbl WHERE a < 5 WITH CHECK OPTION;

INSERT INTO parent_tbl (a) VALUES(1),(5);

EXPLAIN (VERBOSE, COSTS OFF)

UPDATE rw_view SET b = 'text', c = 123.456;

QUERY PLAN

-------------------------------------------------------------------------------------------------

Update on public.parent_tbl

Foreign Update on public.child_foreign parent_tbl_1

Remote SQL: UPDATE public.child_local SET b = $2, c = $3 WHERE ctid = $1 RETURNING a

-> Foreign Scan on public.child_foreign parent_tbl_1

Output: 'text'::text, 123.456, parent_tbl_1.tableoid, parent_tbl_1.ctid, parent_tbl_1.*

Remote SQL: SELECT b, c, a, ctid FROM public.child_local WHERE ((a < 5)) FOR UPDATE

(6 rows)

UPDATE rw_view SET b = 'text', c = 123.456;

SELECT * FROM parent_tbl ORDER BY a;

a | b | c

---+------+---------

1 | text | 123.456

5 | |

(2 rows)

DROP VIEW rw_view;

DROP TABLE child_local;

DROP FOREIGN TABLE child_foreign;

DROP TABLE sub_parent;

DROP TABLE parent_tbl;

-- ===================================================================

-- test serial columns (ie, sequence-based defaults)

-- ===================================================================

DROPFUNCTION row_before_insupd_trigfunc;

CREATETABLEparent_tbl (aint, btext, cnumeric) PARTITION BY RANGE(a);

CREATETABLEsub_parent (cnumeric, aint, btext) PARTITION BY RANGE(a);

ALTERTABLE parent_tbl ATTACH PARTITION sub_parent FORVALUESFROM (1) TO (10);

CREATETABLEchild_local (btext, cnumeric, aint);

CREATE FOREIGN TABLE child_foreign (btext, cnumeric, aint)

SERVER loopback OPTIONS (table_name'child_local');

ALTERTABLE sub_parent ATTACH PARTITION child_foreign FORVALUESFROM (1) TO (10);

CREATEVIEWrw_viewASSELECT*FROM parent_tblWHERE a<5 WITHCHECK OPTION;

INSERT INTO parent_tbl (a)VALUES(1),(5);

EXPLAIN (VERBOSE, COSTS OFF)

UPDATE rw_viewSET b='text', c=123.456;

UPDATE rw_viewSET b='text', c=123.456;

SELECT*FROM parent_tblORDER BY a;

DROPVIEW rw_view;

DROPTABLE child_local;

DROP FOREIGN TABLE child_foreign;

DROPTABLE sub_parent;

DROPTABLE parent_tbl;

staticBitmapset*translate_col_privs_multilevel(PlannerInfo*root,

RelOptInfo*rel,

RelOptInfo*top_parent_rel,

Bitmapset*top_parent_cols);

Bitmapset*parent_cols);

staticvoidexpand_appendrel_subquery(PlannerInfo*root,RelOptInfo*rel,

RangeTblEntry*rte,Indexrti);

translate_col_privs_multilevel(PlannerInfo*root,RelOptInfo*rel,

RelOptInfo*top_parent_rel,

Bitmapset*top_parent_cols)

Bitmapset*parent_cols)

{

Bitmapset*result;

AppendRelInfo*appinfo;

if (top_parent_cols==NULL)

if (parent_cols==NULL)

returnNULL;

if (rel->parent!=top_parent_rel)

{

if (rel->parent)

result=translate_col_privs_multilevel(root,rel->parent,

top_parent_rel,

top_parent_cols);

parent_cols=translate_col_privs_multilevel(root,rel->parent,

top_parent_rel,

parent_cols);

elog(ERROR,"rel with relid %u is not a child rel",rel->relid);

}

appinfo=root->append_rel_array[rel->relid];

Assert(appinfo!=NULL);

result=translate_col_privs(top_parent_cols,appinfo->translated_vars);

returnresult;

returntranslate_col_privs(parent_cols,appinfo->translated_vars);

}