diff options
| author | Dean Rasheed | 2017-06-21 09:43:17 +0000 |
|---|---|---|
| committer | Dean Rasheed | 2017-06-21 09:43:17 +0000 |
| commit | bcbf392ec84362040faf72daad22c647c74e2b2a (patch) | |
| tree | ffb74cdf9b3c488bdbe233e4a59a0ca9156aae0e /src/backend/rewrite | |
| parent | ba1f017069dd87d309e2716bf08a40df42b29baa (diff) | |
Prevent table partitions from being turned into views.
A table partition must be a table, not a view, so don't allow a
"_RETURN" rule to be added that would convert an existing table
partition into a view.
Amit Langote
Discussion: https://postgr.es/m/CAEZATCVzFcAjZwC1bTFvJ09skB_sgkF4SwPKMywev-XTnimp9Q%40mail.gmail.com
Diffstat (limited to 'src/backend/rewrite')
| -rw-r--r-- | src/backend/rewrite/rewriteDefine.c | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/backend/rewrite/rewriteDefine.c b/src/backend/rewrite/rewriteDefine.c index fd3768de171..4213bafa270 100644 --- a/src/backend/rewrite/rewriteDefine.c +++ b/src/backend/rewrite/rewriteDefine.c @@ -428,6 +428,12 @@ DefineQueryRewrite(char *rulename, errmsg("could not convert partitioned table \"%s\" to a view", RelationGetRelationName(event_relation)))); + if (event_relation->rd_rel->relispartition) + ereport(ERROR, + (errcode(ERRCODE_WRONG_OBJECT_TYPE), + errmsg("could not convert partition \"%s\" to a view", + RelationGetRelationName(event_relation)))); + snapshot = RegisterSnapshot(GetLatestSnapshot()); scanDesc = heap_beginscan(event_relation, snapshot, 0, NULL); if (heap_getnext(scanDesc, ForwardScanDirection) != NULL) |