Horton

Teach relation_is_updatable() about partitioned tables.

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

View on postgr.es
Commit: b6263cd851ef245a5dc38119448e029ca1592da4
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2017-06-13T16:30:36Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/rewrite/rewriteHandler.c modified +4 −2
src/test/regress/expected/updatable_views.out modified +36 −0
src/test/regress/sql/updatable_views.sql modified +10 −0

Discussion