]> granicus.if.org Git - postgresql/commit
Teach relation_is_updatable() about partitioned tables.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 13 Jun 2017 16:30:36 +0000 (17:30 +0100)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 13 Jun 2017 16:30:36 +0000 (17:30 +0100)
commitb6263cd851ef245a5dc38119448e029ca1592da4
treed28b5673ba232a537cdde049b1fbd7a1378c2e94
parent2e3fc7a7d322289c70f89199be0a5e899ec7d9b9
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
src/backend/rewrite/rewriteHandler.c
src/test/regress/expected/updatable_views.out
src/test/regress/sql/updatable_views.sql