pgsql: Include partitioned indexes to system view pg_indexes

2018-12-17 Thread Michael Paquier
Include partitioned indexes to system view pg_indexes pg_tables already includes partitioned tables, so for consistency pg_indexes should show partitioned indexes. Author: Suraj Kharage Reviewed-by: Amit Langote, Michael Paquier Discussion: https://postgr.es/m/CAF1DzPVrYo4XNTEnc=PqVp6aLJc7LFYpYR

pgsql: Tweak description comments in tests for partition functions

2018-12-17 Thread Michael Paquier
Tweak description comments in tests for partition functions The new wording is more generic and fixes one grammar mistake and one typo on the way. Per discussion between Amit Langote and me. Discussion: https://postgr.es/m/20181217064028.gj31...@paquier.xyz Branch -- master Details ---

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ed6f15eb3

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a7

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5c

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/91

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/da

pgsql: Update project link of pgBadger in documentation

2018-12-17 Thread Michael Paquier
Update project link of pgBadger in documentation The project has moved to a new place. Reported-by: Peter Neave Discussion: https://postgr.es/m/154474118231.5066.16352227860913505...@wrigleys.postgresql.org Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b6

pgsql: Include ALTER INDEX SET STATISTICS in pg_dump

2018-12-17 Thread Michael Paquier
Include ALTER INDEX SET STATISTICS in pg_dump The new grammar pattern of ALTER INDEX SET STATISTICS able to use column numbers on top of the existing column names introduced by commit 5b6d13e forgot to add support for the feature in pg_dump, so defining statistics on index columns was missing from

pgsql: Include ALTER INDEX SET STATISTICS in pg_dump

2018-12-17 Thread Michael Paquier
Include ALTER INDEX SET STATISTICS in pg_dump The new grammar pattern of ALTER INDEX SET STATISTICS able to use column numbers on top of the existing column names introduced by commit 5b6d13e forgot to add support for the feature in pg_dump, so defining statistics on index columns was missing from

pgsql: Drop support for getting signal descriptions from sys_siglist[].

2018-12-17 Thread Tom Lane
Drop support for getting signal descriptions from sys_siglist[]. It appears that all platforms that have sys_siglist[] also have strsignal(), making that fallback case in pg_strsignal() dead code. Getting rid of it allows dropping a configure test, which seems worth more than providing textual sig

pgsql: Fix tablespace handling for partitioned tables

2018-12-17 Thread Alvaro Herrera
Fix tablespace handling for partitioned tables When partitioned tables were introduced, we failed to realize that by copying the tablespace handling for other relation kinds with no physical storage we were causing the secondary effect that their partitions would not automatically inherit the tabl

pgsql: Clarify runtime pruning in EXPLAIN

2018-12-17 Thread Alvaro Herrera
Clarify runtime pruning in EXPLAIN Author: Amit Langote Reviewed-by: David Rowley Discussion: https://postgr.es/m/002dec69-9afb-b621-5630-235eceafe...@lab.ntt.co.jp Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f760a8b5cc1fa8c9d341faaf2cbda3b94d5a20d9 Mod

pgsql: Clarify runtime pruning in EXPLAIN

2018-12-17 Thread Alvaro Herrera
Clarify runtime pruning in EXPLAIN Author: Amit Langote Reviewed-by: David Rowley Discussion: https://postgr.es/m/002dec69-9afb-b621-5630-235eceafe...@lab.ntt.co.jp Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1e6240a3fe919e19676875927681a861e13f93c2 Modified F

pgsql: Remove extra semicolons.

2018-12-17 Thread Amit Kapila
Remove extra semicolons. Reported-by: David Rowley Author: David Rowley Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion: https://postgr.es/m/cakjs1f8eneeyyzzvdjahvz6gbahfkhbsfb5m_c0y6tujs9d...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff

pgsql: Remove extra semicolons.

2018-12-17 Thread Amit Kapila
Remove extra semicolons. Reported-by: David Rowley Author: David Rowley Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion: https://postgr.es/m/cakjs1f8eneeyyzzvdjahvz6gbahfkhbsfb5m_c0y6tujs9d...@mail.gmail.com Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: Remove extra semicolons.

2018-12-17 Thread Amit Kapila
Remove extra semicolons. Reported-by: David Rowley Author: David Rowley Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion: https://postgr.es/m/cakjs1f8eneeyyzzvdjahvz6gbahfkhbsfb5m_c0y6tujs9d...@mail.gmail.com Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/com