pgsql: Add missed tag in bloom.sgml

2018-10-14 Thread Alexander Korotkov
Add missed tag in bloom.sgml Backpatch commits don't contain this error. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/981b64f840ba81adf47ea0c34694ea416134817e Modified Files -- doc/src/sgml/bloom.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 dele

pgsql: contrib/bloom documentation improvement

2018-10-14 Thread Alexander Korotkov
contrib/bloom documentation improvement This commit documents rounding of "length" parameter and absence of support for unique indexes and NULLs searching. Backpatch to 9.6 where contrib/bloom was introduced. Discussion: https://postgr.es/m/CAF4Au4wPQQ7EHVSnzcLjsbY3oLSzVk6UemZLD1Sbmwysy3R61g%40

pgsql: contrib/bloom documentation improvement

2018-10-14 Thread Alexander Korotkov
contrib/bloom documentation improvement This commit documents rounding of "length" parameter and absence of support for unique indexes and NULLs searching. Backpatch to 9.6 where contrib/bloom was introduced. Discussion: https://postgr.es/m/CAF4Au4wPQQ7EHVSnzcLjsbY3oLSzVk6UemZLD1Sbmwysy3R61g%40

pgsql: contrib/bloom documentation improvement

2018-10-14 Thread Alexander Korotkov
contrib/bloom documentation improvement This commit documents rounding of "length" parameter and absence of support for unique indexes and NULLs searching. Backpatch to 9.6 where contrib/bloom was introduced. Discussion: https://postgr.es/m/CAF4Au4wPQQ7EHVSnzcLjsbY3oLSzVk6UemZLD1Sbmwysy3R61g%40

pgsql: contrib/bloom documentation improvement

2018-10-14 Thread Alexander Korotkov
contrib/bloom documentation improvement This commit documents rounding of "length" parameter and absence of support for unique indexes and NULLs searching. Backpatch to 9.6 where contrib/bloom was introduced. Discussion: https://postgr.es/m/CAF4Au4wPQQ7EHVSnzcLjsbY3oLSzVk6UemZLD1Sbmwysy3R61g%40

pgsql: Make some subquery-using test cases a bit more robust.

2018-10-14 Thread Tom Lane
Make some subquery-using test cases a bit more robust. These test cases could be adversely affected by an upcoming change to allow pullup of FROM-less subqueries. Tweak them to ensure that they'll continue to test what they did before. Discussion: https://postgr.es/m/5395.1539275...@sss.pgh.pa.u

Re: pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Andres Freund
On 2018-10-14 13:26:24 +, Michael Paquier wrote: > Avoid duplicate XIDs at recovery when building initial snapshot > > On a primary, sets of XLOG_RUNNING_XACTS records are generated on a > periodic basis to allow recovery to build the initial state of > transactions for a hot standby. The set

pgsql: Use PlaceHolderVars within the quals of a FULL JOIN.

2018-10-14 Thread Tom Lane
Use PlaceHolderVars within the quals of a FULL JOIN. This prevents failures in cases where we pull up a constant or var-free expression from a subquery and put it into a full join's qual. That can result in not recognizing the qual as containing a mergejoin-able or hashjoin-able condition. A PHV

pgsql: Clean up/tighten up coercibility checks in opr_sanity regression

2018-10-14 Thread Tom Lane
Clean up/tighten up coercibility checks in opr_sanity regression test. With the removal of the old abstime type, there are no longer any cases in this test where we need to use the weaker castcontext-ignoring form of binary coercibility check. (The other major source of such headaches, apparently

Re: pgsql: Add list of acknowledgments to release notes

2018-10-14 Thread Tom Lane
Peter Eisentraut writes: > On 14/10/2018 04:03, Tom Lane wrote: >> I wonder how well these characters will render in different viewing >> tools. Maybe there's not much to be done, but should we entity-ify >> the list where possible? > This is not related to the encoding of these characters in th

Re: pgsql: Add list of acknowledgments to release notes

2018-10-14 Thread Peter Eisentraut
On 14/10/2018 04:03, Tom Lane wrote: > Oct 13, 2018 9:58:10 PM org.apache.fop.events.LoggingEventListener > processEvent > WARNING: Glyph "?" (0x144, nacute) not available in font "Times-Roman". > Oct 13, 2018 9:58:10 PM org.apache.fop.events.LoggingEventListener > processEvent > WARNING: Glyph "

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P

pgsql: Avoid duplicate XIDs at recovery when building initial snapshot

2018-10-14 Thread Michael Paquier
Avoid duplicate XIDs at recovery when building initial snapshot On a primary, sets of XLOG_RUNNING_XACTS records are generated on a periodic basis to allow recovery to build the initial state of transactions for a hot standby. The set of transaction IDs is created by scanning all the entries in P