pgsql: Fix typo in comment of commit_ts.c for incorrect reference to CL

2018-06-21 Thread Michael Paquier
Fix typo in comment of commit_ts.c for incorrect reference to CLOG Author: Shao Bret Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0aa5e65ab4fd2695f0e4108b9ec53a0546261e1f Modified Files -- src/backend/access/transam/commit_ts.c | 3 ++- 1 file changed

pgsql: Improve coding pattern in Parallel Append code.

2018-06-21 Thread Amit Kapila
Improve coding pattern in Parallel Append code. The create_append_path code didn't consider that list_concat will modify it's first argument leading to inconsistent traversal of resulting list. In practice, it won't lead to any user-visible bug but changing it for making the code behave consisten

pgsql: Disclaim support for default namespace in XMLTABLE

2018-06-21 Thread Alvaro Herrera
Disclaim support for default namespace in XMLTABLE Pavel Stehule's original patch had support for default namespace, but I ripped it out before commit -- hence the docs were correct when written, and I broke them by omission :-(. Remove the offending phrase. Author: Daniel Gustafsson Discussion:

pgsql: Disclaim support for default namespace in XMLTABLE

2018-06-21 Thread Alvaro Herrera
Disclaim support for default namespace in XMLTABLE Pavel Stehule's original patch had support for default namespace, but I ripped it out before commit -- hence the docs were correct when written, and I broke them by omission :-(. Remove the offending phrase. Author: Daniel Gustafsson Discussion:

pgsql: Fix partial aggregation for variance(int4) and related aggregate

2018-06-21 Thread Tom Lane
Fix partial aggregation for variance(int4) and related aggregates. A typo in numeric_poly_combine caused bogus results for queries using it, but of course would only manifest if parallel aggregation is performed. Reported by Rajkumar Raghuwanshi. David Rowley did the diagnosis and the fix; I edi

pgsql: Fix partial aggregation for variance(int4) and related aggregate

2018-06-21 Thread Tom Lane
Fix partial aggregation for variance(int4) and related aggregates. A typo in numeric_poly_combine caused bogus results for queries using it, but of course would only manifest if parallel aggregation is performed. Reported by Rajkumar Raghuwanshi. David Rowley did the diagnosis and the fix; I edi

pgsql: Set correct context for XPath evaluation

2018-06-21 Thread Alvaro Herrera
Set correct context for XPath evaluation According to the SQL standard, the context of XMLTABLE's XPath row_expression is the document node of the XML input document, not the root node. This becomes visible when a relative path rather than absolute is used as row expression. Absolute paths is wh

pgsql: Improve requirements documentation for ldap test suite.

2018-06-21 Thread Tom Lane
Improve requirements documentation for ldap test suite. Text by me; data contributed by me, Thomas Munro, Michael Paquier. Discussion: https://postgr.es/m/20180521013425.ga4...@paquier.xyz Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/425b4c082c82672c646ed8bc9e14

pgsql: Fix mishandling of sortgroupref labels while splitting SRF targe

2018-06-21 Thread Tom Lane
Fix mishandling of sortgroupref labels while splitting SRF targetlists. split_pathtarget_at_srfs() neglected to worry about sortgroupref labels in the intermediate PathTargets it constructs. I think we'd supposed that their labeling didn't matter, but it does at least for the case that GroupAggre

pgsql: Fix mishandling of sortgroupref labels while splitting SRF targe

2018-06-21 Thread Tom Lane
Fix mishandling of sortgroupref labels while splitting SRF targetlists. split_pathtarget_at_srfs() neglected to worry about sortgroupref labels in the intermediate PathTargets it constructs. I think we'd supposed that their labeling didn't matter, but it does at least for the case that GroupAggre

pgsql: Improve wording of release notes item

2018-06-21 Thread Alexander Korotkov
Improve wording of release notes item PostgreSQL 11 introduces compress method for SP-GiST opclasses. That was mistakenly interpreted as compression support for SP-GiST while actually that allows lossy representation of leaf keys. Author: Alexander Korotkov, based on proposal by Darafei Praliask