Horton

Teach PL/pgSQL about partitioned tables.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: d3c3f2b1e25cc96d3078bf4d47a2f58fefb70560
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2017-06-14T08:00:01Z
Releases: 10.0 
Teach PL/pgSQL about partitioned tables.

Table partitioning, introduced in commit f0e44751d7, added a new
relkind - RELKIND_PARTITIONED_TABLE. Update a couple of places in
PL/pgSQL to handle it. Specifically plpgsql_parse_cwordtype() and
build_row_from_class() needed updating in order to make table%ROWTYPE
and table.col%TYPE work for partitioned tables.

Dean Rasheed, reviewed by Amit Langote.

Discussion: https://postgr.es/m/CAEZATCUnNOKN8sLML9jUzxecALWpEXK3a3W7y0PgFR4%2Buhgc%3Dg%40mail.gmail.com

Files

PathChange+/−
src/pl/plpgsql/src/pl_comp.c modified +4 −2
src/test/regress/expected/plpgsql.out modified +45 −0
src/test/regress/sql/plpgsql.sql modified +39 −0

Discussion