Horton

Prevent table partitions from being turned into views.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: bcbf392ec84362040faf72daad22c647c74e2b2a
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2017-06-21T09:43:17Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/rewrite/rewriteDefine.c modified +6 −0
src/test/regress/expected/rules.out modified +5 −0
src/test/regress/sql/rules.sql modified +5 −0

Discussion