| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Teach relation_is_updatable() about partitioned tables. |
| Date: | 2017-06-13 16:33:16 |
| Message-ID: | E1dKokm-0002Ba-AO@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-06-13 16:41:13 | pgsql: Always initialize PartitionBoundInfoData's null_index. |
| Previous Message | Tom Lane | 2017-06-13 16:22:49 | Re: pgindent (was Re: [COMMITTERS] pgsql: Preventive maintenance in advance of pgindent run.) |