From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Teach PL/pgSQL about partitioned tables. |
Date: | 2017-06-14 08:01:15 |
Message-ID: | E1dL3Ep-00030O-5d@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/d3c3f2b1e25cc96d3078bf4d47a2f58fefb70560
Modified Files
--------------
src/pl/plpgsql/src/pl_comp.c | 6 +++--
src/test/regress/expected/plpgsql.out | 45 +++++++++++++++++++++++++++++++++++
src/test/regress/sql/plpgsql.sql | 39 ++++++++++++++++++++++++++++++
3 files changed, 88 insertions(+), 2 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-06-14 14:26:53 | pgsql: Fix violations of CatalogTupleInsert/Update/Delete abstraction. |
Previous Message | Dean Rasheed | 2017-06-14 07:45:03 | pgsql: Teach RemoveRoleFromObjectPolicy() about partitioned tables. |