pgsql: Add pg_promote function

2018-10-24 Thread Michael Paquier
Add pg_promote function This function is able to promote a standby with this new SQL-callable function. Execution access can be granted to non-superusers so that failover tools can observe the principle of least privilege. Catalog version is bumped. Author: Laurenz Albe Reviewed-by: Michael Paq

pgsql: Improve unconstify() documentation

2018-10-24 Thread Peter Eisentraut
Improve unconstify() documentation Refer to expression instead of variable when appropriate. Discussion: https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f2898de98a5407a8b7

pgsql: Apply unconstify() in more places

2018-10-24 Thread Peter Eisentraut
Apply unconstify() in more places Discussion: https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0a8590b2a09e7a9e10612bc38d5e872b0c234eca Modified Files -- src/ba

pgsql: Fix typo in regression test comment

2018-10-24 Thread Andrew Dunstan
Fix typo in regression test comment per Michael Banck Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ef4583238b9ceaca728a27aea711a5f467dc49d5 Modified Files -- src/test/regress/expected/fast_default.out | 2 +- src/test/regress/sql/fast_default.s

pgsql: Fix typo in regression test comment

2018-10-24 Thread Andrew Dunstan
Fix typo in regression test comment per Michael Banck Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4beea5508e80a65a90f3fa857ea34ec71b9d6db2 Modified Files -- src/test/regress/expected/fast_default.out | 2 +- src/test/regress/sql/fast_default.sql

pgsql: Correctly set t_self for heap tuples in expand_tuple

2018-10-24 Thread Andrew Dunstan
Correctly set t_self for heap tuples in expand_tuple Commit 16828d5c0 incorrectly set an invalid pointer for t_self for heap tuples. This patch correctly copies it from the source tuple, and includes a regression test that relies on it being set correctly. Backpatch to release 11. Fixes bug #154

pgsql: Correctly set t_self for heap tuples in expand_tuple

2018-10-24 Thread Andrew Dunstan
Correctly set t_self for heap tuples in expand_tuple Commit 16828d5c0 incorrectly set an invalid pointer for t_self for heap tuples. This patch correctly copies it from the source tuple, and includes a regression test that relies on it being set correctly. Backpatch to release 11. Fixes bug #154

pgsql: List wait events in alphabetical order

2018-10-24 Thread Michael Paquier
List wait events in alphabetical order This changes the documentation, and the related structures so as everything is consistent. Some wait events were not listed alphabetically since their introduction, others have been added rather randomly. Keeping all those entries in order helps in maintena

pgsql: List wait events in alphabetical order in documentation

2018-10-24 Thread Michael Paquier
List wait events in alphabetical order in documentation Keeping all those entries in order helps the user looking at the documentation in finding them. Author: Michael Paquier, Kuntal Ghosh Discussion: https://postgr.es/m/[email protected] Branch -- REL_11_STABLE Details

pgsql: List wait events in alphabetical order in documentation

2018-10-24 Thread Michael Paquier
List wait events in alphabetical order in documentation Keeping all those entries in order helps the user looking at the documentation in finding them. Author: Michael Paquier, Kuntal Ghosh Discussion: https://postgr.es/m/[email protected] Branch -- REL_10_STABLE Details