[COMMITTERS] pgsql: Cleanup of rewriter and planner handling of Query.hasRowSecurity

2016-11-10 Thread Tom Lane
Cleanup of rewriter and planner handling of Query.hasRowSecurity flag. Be sure to pull up the subquery's hasRowSecurity flag when flattening a subquery in pull_up_simple_subquery(). This isn't a bug today because we don't look at the hasRowSecurity flag during planning, but it could easily be a b

[COMMITTERS] pgsql: Re-allow user_catalog_table option for materialized views.

2016-11-10 Thread Tom Lane
Re-allow user_catalog_table option for materialized views. The reloptions stuff allows this option to be set on a matview. While it's questionable whether that is useful or was really intended, it does work, and we shouldn't change that in minor releases. Commit e3e66d8a9 disabled the option sinc

[COMMITTERS] pgsql: Re-allow user_catalog_table option for materialized views.

2016-11-10 Thread Tom Lane
Re-allow user_catalog_table option for materialized views. The reloptions stuff allows this option to be set on a matview. While it's questionable whether that is useful or was really intended, it does work, and we shouldn't change that in minor releases. Commit e3e66d8a9 disabled the option sinc

[COMMITTERS] pgsql: Re-allow user_catalog_table option for materialized views.

2016-11-10 Thread Tom Lane
Re-allow user_catalog_table option for materialized views. The reloptions stuff allows this option to be set on a matview. While it's questionable whether that is useful or was really intended, it does work, and we shouldn't change that in minor releases. Commit e3e66d8a9 disabled the option sinc

[COMMITTERS] pgsql: Support "COPY view FROM" for views with INSTEAD OF INSERT trigge

2016-11-10 Thread Tom Lane
Support "COPY view FROM" for views with INSTEAD OF INSERT triggers. We just pass the data to the INSTEAD trigger. Haribabu Kommi, reviewed by Dilip Kumar Patch: Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/279c439c7fbc1bcb52173d92dd3b1fbe63e497ab Modified File

[COMMITTERS] pgsql: Fix partial aggregation for the case of a degenerate GROUP BY cl

2016-11-10 Thread Tom Lane
Fix partial aggregation for the case of a degenerate GROUP BY clause. The plan generated for sorted partial aggregation with "GROUP BY constant" included a Sort node with no sort keys, which the executor does not like. Per report from Steve Randall. I'd add a regression test case if I could thin

[COMMITTERS] pgsql: Fix partial aggregation for the case of a degenerate GROUP BY cl

2016-11-10 Thread Tom Lane
Fix partial aggregation for the case of a degenerate GROUP BY clause. The plan generated for sorted partial aggregation with "GROUP BY constant" included a Sort node with no sort keys, which the executor does not like. Per report from Steve Randall. I'd add a regression test case if I could thin

[COMMITTERS] pgsql: Doc: improve link.

2016-11-10 Thread Tom Lane
Doc: improve link. Discussion: <[email protected]> Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0b1b5033ac19236a4a23eed9232d74936717020e Modified Files -- doc/src/sgml/storage.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --