diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-07-03 12:26:19 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-07-03 12:26:52 -0400 |
| commit | 5530a826434a8d4bc6ba7387d05aa14755406199 (patch) | |
| tree | 4f035da4cc1e90691fc6c69a1cd8953da49827e9 /src/backend | |
| parent | 620935ad088d4779ed7fa65f38a876b30e01dee4 (diff) | |
| download | postgresql-5530a826434a8d4bc6ba7387d05aa14755406199.tar.gz postgresql-5530a826434a8d4bc6ba7387d05aa14755406199.zip | |
Fix handling of auto-updatable views on inherited tables.
An INSERT into such a view should work just like an INSERT into its base
table, ie the insertion should go directly into that table ... not be
duplicated into each child table, as was happening before, per bug #8275
from Rushabh Lathia. On the other hand, the current behavior for
UPDATE/DELETE seems reasonable: the update/delete traverses the child
tables, or not, depending on whether the view specifies ONLY or not.
Add some regression tests covering this area.
Dean Rasheed
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/rewrite/rewriteHandler.c | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c index d4b97081950..d909de3a539 100644 --- a/src/backend/rewrite/rewriteHandler.c +++ b/src/backend/rewrite/rewriteHandler.c @@ -2389,6 +2389,13 @@ rewriteTargetView(Query *parsetree, Relation view) new_rt_index = list_length(parsetree->rtable); /* + * INSERTs never inherit. For UPDATE/DELETE, we use the view query's + * inheritance flag for the base relation. + */ + if (parsetree->commandType == CMD_INSERT) + new_rte->inh = false; + + /* * Make a copy of the view's targetlist, adjusting its Vars to reference * the new target RTE, ie make their varnos be new_rt_index instead of * base_rt_index. There can be no Vars for other rels in the tlist, so |