pgsql: doc: Change libpq function ids to mixed case

2019-07-26 Thread Peter Eisentraut
doc: Change libpq function ids to mixed case The ids for linking to libpq functions were previously all lower-case. Change to mixed-case, matching the actual function name, for easier readability in the source. The output isn't changed in a significant way, since the ids are converted to lower or

pgsql: doc: Fix some markup whitespace issues

2019-07-26 Thread Peter Eisentraut
doc: Fix some markup whitespace issues When making an xref to a varlistentry, the stylesheets use the first as the link text. In the cases fixed here, the element contained extra whitespace that ended up being part of the link text, which looked strange in the output in some cases. This whites

pgsql: doc: Add support for xref to command and function elements

2019-07-26 Thread Peter Eisentraut
doc: Add support for xref to command and function elements Discussion: https://www.postgresql.org/message-id/517abe28-8a93-5b7a-ff40-b1fd61d33b26%402ndquadrant.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2e32a7711a8a6e3020c9fb431705dadaed305120 Modified Fi

pgsql: doc: Make libpq documentation navigable between functions

2019-07-26 Thread Peter Eisentraut
doc: Make libpq documentation navigable between functions Turn most mentions of libpq functions into links. At id attributes to most libpq functions, where not existing yet, so that they can be linked to. (In a handful of cases there were problems with the PDF processing toolchain, so those inst

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Fix loss of fractional digits for large values in cash_numeric()

2019-07-26 Thread Tom Lane
Fix loss of fractional digits for large values in cash_numeric(). Money values exceeding about 18 digits (depending on lc_monetary) could be inaccurately converted to numeric, due to select_div_scale() deciding it didn't need to compute any fractional digits. Force its hand by setting the dscale

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Avoid choosing "localtime" or "posixrules" as TimeZone during in

2019-07-26 Thread Tom Lane
Avoid choosing "localtime" or "posixrules" as TimeZone during initdb. Some platforms create a file named "localtime" in the system timezone directory, making it a copy or link to the active time zone file. If Postgres is built with --with-system-tzdata, initdb will see that file as an exact match

pgsql: Tweak our special-case logic for the IANA "Factory" timezone.

2019-07-26 Thread Tom Lane
Tweak our special-case logic for the IANA "Factory" timezone. pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psq

pgsql: Fix possible lockup in pgbench with -R.

2019-07-26 Thread Tom Lane
Fix possible lockup in pgbench with -R. pgbench would sometimes get stuck waiting forever after its last client thread terminated, due to failing to check for there being nothing more to wait for. Bug introduced during refactoring in v10 (I didn't bother to try to assign blame to a specific commi

pgsql: Fix possible lockup in pgbench with -R.

2019-07-26 Thread Tom Lane
Fix possible lockup in pgbench with -R. pgbench would sometimes get stuck waiting forever after its last client thread terminated, due to failing to check for there being nothing more to wait for. Bug introduced during refactoring in v10 (I didn't bother to try to assign blame to a specific commi

pgsql: Don't uselessly escape a string that doesn't need escaping

2019-07-26 Thread Alvaro Herrera
Don't uselessly escape a string that doesn't need escaping Per gripe from Ian Barwick Co-authored-by: Ian Barwick Discussion: https://postgr.es/m/cabvvfjwnnnkb8chstlhktsvl1+g6bvcv+57+w1jz61p8ygp...@mail.gmail.com Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commit

pgsql: Don't uselessly escape a string that doesn't need escaping

2019-07-26 Thread Alvaro Herrera
Don't uselessly escape a string that doesn't need escaping Per gripe from Ian Barwick Co-authored-by: Ian Barwick Discussion: https://postgr.es/m/cabvvfjwnnnkb8chstlhktsvl1+g6bvcv+57+w1jz61p8ygp...@mail.gmail.com Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commit

pgsql: Don't uselessly escape a string that doesn't need escaping

2019-07-26 Thread Alvaro Herrera
Don't uselessly escape a string that doesn't need escaping Per gripe from Ian Barwick Co-authored-by: Ian Barwick Discussion: https://postgr.es/m/cabvvfjwnnnkb8chstlhktsvl1+g6bvcv+57+w1jz61p8ygp...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/09

pgsql: Don't uselessly escape a string that doesn't need escaping

2019-07-26 Thread Alvaro Herrera
Don't uselessly escape a string that doesn't need escaping Per gripe from Ian Barwick Co-authored-by: Ian Barwick Discussion: https://postgr.es/m/cabvvfjwnnnkb8chstlhktsvl1+g6bvcv+57+w1jz61p8ygp...@mail.gmail.com Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commit

pgsql: Don't uselessly escape a string that doesn't need escaping

2019-07-26 Thread Alvaro Herrera
Don't uselessly escape a string that doesn't need escaping Per gripe from Ian Barwick Co-authored-by: Ian Barwick Discussion: https://postgr.es/m/cabvvfjwnnnkb8chstlhktsvl1+g6bvcv+57+w1jz61p8ygp...@mail.gmail.com Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commit

pgsql: Fix typo in pg_upgrade file header

2019-07-26 Thread Peter Eisentraut
Fix typo in pg_upgrade file header Author: Daniel Gustafsson Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/28cb0555c1153a0dcdf1c908d7265acafa413b57 Modified Files -- src/bin/pg_upgrade/option.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: pg_upgrade: Check all used executables

2019-07-26 Thread Peter Eisentraut
pg_upgrade: Check all used executables Expand the validate_exec() calls to cover all the used binaries. Author: Daniel Gustafsson Reviewed-by: Peter Eisentraut Discussion: https://www.postgresql.org/message-id/flat/[email protected] Branch -- master Details --- https://gi

pgsql: pg_upgrade: Update obsolescent documentation note

2019-07-26 Thread Peter Eisentraut
pg_upgrade: Update obsolescent documentation note Recently released xfsprogs 5.1.0 has reflink support enabled by default, so the note that it's not enabled by default can be removed. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4552c0f57160ab3eeaf1620ebb969c

pgsql: pg_upgrade: Default new bindir to pg_upgrade location

2019-07-26 Thread Peter Eisentraut
pg_upgrade: Default new bindir to pg_upgrade location Make the directory where the pg_upgrade binary resides the default for new bindir, as running the pg_upgrade binary from where the new cluster is installed is a very common scenario. Setting this as the defauly bindir for the new cluster will

pgsql: pg_upgrade: Update obsolescent documentation note

2019-07-26 Thread Peter Eisentraut
pg_upgrade: Update obsolescent documentation note Recently released xfsprogs 5.1.0 has reflink support enabled by default, so the note that it's not enabled by default can be removed. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/66190f371d8a6fd7d2ab5018704