diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-01-24 15:46:50 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-01-24 15:46:50 -0500 |
| commit | 587cda35ca331128db6c61d406d312654572834a (patch) | |
| tree | 421e5870d1adb74dce14a58868b5fb30c87f0d12 /src/backend/rewrite/rewriteHandler.c | |
| parent | 132488bfee687865375b5410f18a78fb55bd7015 (diff) | |
| download | postgresql-587cda35ca331128db6c61d406d312654572834a.tar.gz postgresql-587cda35ca331128db6c61d406d312654572834a.zip | |
Fix things so that updatable views work with partitioned tables.
Previously, ExecInitModifyTable was missing handling for WITH CHECK
OPTION, and view_query_is_auto_updatable was missing handling for
RELKIND_PARTITIONED_TABLE.
Amit Langote, reviewed by me.
Diffstat (limited to 'src/backend/rewrite/rewriteHandler.c')
| -rw-r--r-- | src/backend/rewrite/rewriteHandler.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c index d1ff3b20b63..d3e44fb1350 100644 --- a/src/backend/rewrite/rewriteHandler.c +++ b/src/backend/rewrite/rewriteHandler.c @@ -2249,7 +2249,8 @@ view_query_is_auto_updatable(Query *viewquery, bool check_cols) if (base_rte->rtekind != RTE_RELATION || (base_rte->relkind != RELKIND_RELATION && base_rte->relkind != RELKIND_FOREIGN_TABLE && - base_rte->relkind != RELKIND_VIEW)) + base_rte->relkind != RELKIND_VIEW && + base_rte->relkind != RELKIND_PARTITIONED_TABLE)) return gettext_noop("Views that do not select from a single table or view are not automatically updatable."); if (base_rte->tablesample) |