Thread: [COMMITTERS] pgsql: Teach relation_is_updatable() about partitioned tables.

[COMMITTERS] pgsql: Teach relation_is_updatable() about partitioned tables.

From
Dean Rasheed
Date:
Teach relation_is_updatable() about partitioned tables.

Table partitioning, introduced in commit f0e44751d7, added a new
relkind - RELKIND_PARTITIONED_TABLE. Update relation_is_updatable() to
handle it. Specifically, partitioned tables and simple views built on
top of them are updatable.

This affects the SQL-callable functions pg_relation_is_updatable() and
pg_column_is_updatable(), and the views information_schema.views and
information_schema.columns.

Dean Rasheed, reviewed by Ashutosh Bapat.

Discussion: https://postgr.es/m/CAEZATCXnbiFkMXgF4Ez1pmM2c-tS1z33bSq7OGbw7QQhHov%2B6Q%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b6263cd851ef245a5dc38119448e029ca1592da4

Modified Files
--------------
src/backend/rewrite/rewriteHandler.c          |  6 +++--
src/test/regress/expected/updatable_views.out | 36 +++++++++++++++++++++++++++
src/test/regress/sql/updatable_views.sql      | 10 ++++++++
3 files changed, 50 insertions(+), 2 deletions(-)