pgsql: Error message refactoring

2020-06-14 Thread Peter Eisentraut
Error message refactoring Take some untranslatable things out of the message and replace by format placeholders, to reduce translatable strings and reduce translation mistakes. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/47d4d0cfad6921fe1f6aabacc8a7a328ce9acb76

pgsql: Bump catversion for ACL changes on replication origin functions

2020-06-14 Thread Michael Paquier
Bump catversion for ACL changes on replication origin functions Oversight in cc07264. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/46241b28d84551bf6aeec3aa7e2391cda2757a21 Mo

Re: pgsql: Fix behavior of exp() and power() for infinity inputs.

2020-06-14 Thread Tom Lane
Michael Paquier writes: > On Sun, Jun 14, 2020 at 03:00:11PM +, Tom Lane wrote: >> Also, add a bunch of test cases verifying that exp() and power() >> actually do follow POSIX for Inf and NaN inputs. While this patch >> should guarantee that exp() passes the tests, power() will not unless >>

Re: pgsql: Fix behavior of exp() and power() for infinity inputs.

2020-06-14 Thread Michael Paquier
On Sun, Jun 14, 2020 at 03:00:11PM +, Tom Lane wrote: > Fix behavior of exp() and power() for infinity inputs. > > Previously, these functions tended to throw underflow errors for > negative-infinity exponents. The correct thing per POSIX is to > return 0, so let's do that instead. (Note tha

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Doc: Add references for SI and SSI.

2020-06-14 Thread Thomas Munro
Doc: Add references for SI and SSI. Our documentation failed to point out that REPEATABLE READ is really snapshot isolation, which might be important to some users. Point to the standard reference paper for this complicated topic. Likewise, add a reference to the VLDB paper about PostgreSQL SSI,

pgsql: Fix behavior of exp() and power() for infinity inputs.

2020-06-14 Thread Tom Lane
Fix behavior of exp() and power() for infinity inputs. Previously, these functions tended to throw underflow errors for negative-infinity exponents. The correct thing per POSIX is to return 0, so let's do that instead. (Note that the SQL standard is silent on such issues, as it lacks the concept