[COMMITTERS] pgsql: Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT n

2013-06-05 Thread Tom Lane
Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests. The planner is aware that it mustn't push down upper-level quals into subqueries if the quals reference subquery output columns that contain set-returning functions or volatile functions, or are non-DISTINCT outputs of a DISTINC

[COMMITTERS] pgsql: Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT n

2013-06-05 Thread Tom Lane
Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests. The planner is aware that it mustn't push down upper-level quals into subqueries if the quals reference subquery output columns that contain set-returning functions or volatile functions, or are non-DISTINCT outputs of a DISTINC

[COMMITTERS] pgsql: Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT n

2013-06-05 Thread Tom Lane
Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests. The planner is aware that it mustn't push down upper-level quals into subqueries if the quals reference subquery output columns that contain set-returning functions or volatile functions, or are non-DISTINCT outputs of a DISTINC

[COMMITTERS] pgsql: Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT n

2013-06-05 Thread Tom Lane
Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests. The planner is aware that it mustn't push down upper-level quals into subqueries if the quals reference subquery output columns that contain set-returning functions or volatile functions, or are non-DISTINCT outputs of a DISTINC

[COMMITTERS] pgsql: Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT n

2013-06-05 Thread Tom Lane
Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT nests. The planner is aware that it mustn't push down upper-level quals into subqueries if the quals reference subquery output columns that contain set-returning functions or volatile functions, or are non-DISTINCT outputs of a DISTINC

[COMMITTERS] pgsql: Update SQL features list

2013-06-05 Thread Peter Eisentraut
Update SQL features list Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a3bd6096bdc6db70ec267116ba52a4cccbd34c2a Modified Files -- src/backend/catalog/sql_features.txt |8 1 file changed, 4 insertions(+), 4 deletions(-) -- Sent via pgsql-c

[COMMITTERS] pgsql: Put analyze_keyword back in explain_option_name production.

2013-06-05 Thread Tom Lane
Put analyze_keyword back in explain_option_name production. In commit 2c92edad48796119c83d7dbe6c33425d1924626d, I broke "EXPLAIN (ANALYZE)" syntax, because I mistakenly thought that ANALYZE/ANALYSE were only partially reserved and thus would be included in NonReservedWord; but actually they're ful

[COMMITTERS] pgsql: Put analyze_keyword back in explain_option_name production.

2013-06-05 Thread Tom Lane
Put analyze_keyword back in explain_option_name production. In commit 2c92edad48796119c83d7dbe6c33425d1924626d, I broke "EXPLAIN (ANALYZE)" syntax, because I mistakenly thought that ANALYZE/ANALYSE were only partially reserved and thus would be included in NonReservedWord; but actually they're ful

[COMMITTERS] pgsql: Put analyze_keyword back in explain_option_name production.

2013-06-05 Thread Tom Lane
Put analyze_keyword back in explain_option_name production. In commit 2c92edad48796119c83d7dbe6c33425d1924626d, I broke "EXPLAIN (ANALYZE)" syntax, because I mistakenly thought that ANALYZE/ANALYSE were only partially reserved and thus would be included in NonReservedWord; but actually they're ful

[COMMITTERS] pgsql: Put analyze_keyword back in explain_option_name production.

2013-06-05 Thread Tom Lane
Put analyze_keyword back in explain_option_name production. In commit 2c92edad48796119c83d7dbe6c33425d1924626d, I broke "EXPLAIN (ANALYZE)" syntax, because I mistakenly thought that ANALYZE/ANALYSE were only partially reserved and thus would be included in NonReservedWord; but actually they're ful