pgsql: docs: Clarify how ALTER TABLE .. SET COMPRESSION works.

2021-05-06 Thread Robert Haas
docs: Clarify how ALTER TABLE .. SET COMPRESSION works. Justin Pryzby, per a complaint from Michael Paquier. Reviewed by Dilip Kumar and by me. Discussion: http://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2d0f6

pgsql: Additional doc fixes for configurable TOAST compression.

2021-05-06 Thread Robert Haas
Additional doc fixes for configurable TOAST compression. The grammar changes in commit bbe0a81db69bd10bd166907c3701492a29aca294 allow SET COMPRESSION to be used with ALTER MATERIALIZED VIEW as well as with ALTER TABLE, so update those docs to say that it works. Also, update the documentation for

pgsql: Doc: trivial wording adjustment.

2021-05-06 Thread Tom Lane
Doc: trivial wording adjustment. Improve self-referential foreign key example, per suggestion from David Johnston. Discussion: https://postgr.es/m/cakfquwztke7+hun4yugqu2+gapi4cy18txmrg_z5nadkxfp...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c3

pgsql: Track detached partitions more accurately in partdescs

2021-05-06 Thread Alvaro Herrera
Track detached partitions more accurately in partdescs In d6b8d29419df I (Álvaro) was sloppy about recording whether a partition descripor does or does not include detached partitions, when the snapshot checking does not see the pg_inherits row marked detached. In that case no partition was omitte

pgsql: Remove overzealous VACUUM visibility map assertion.

2021-05-06 Thread Peter Geoghegan
Remove overzealous VACUUM visibility map assertion. The all_visible_according_to_vm variable's value is inherently prone to becoming invalidated concurrently, since it is set before we even acquire a lock on a related heap page buffer. Oversight in commit 7136bf34, which added the assertion in pa

pgsql: Improve documentation on DETACH PARTITION lock levels

2021-05-06 Thread Alvaro Herrera
Improve documentation on DETACH PARTITION lock levels This was forgotten in 71f4c8c6f74b. Reported-by: Pavel Luzanov Author: Amit Langote Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/com

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: Document lock level used by ALTER TABLE VALIDATE CONSTRAINT

2021-05-06 Thread Alvaro Herrera
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT Backpatch all the way back to 9.6. Author: Simon Riggs Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fd5amhqch09li...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4

pgsql: Remove redundant variable

2021-05-06 Thread Alvaro Herrera
Remove redundant variable Author: Amul Sul Reviewed-by: Jeevan Ladhe Reviewed-by: Bharath Rupireddy Reviewed-by: Justin Pryzby Discussion: https://postgr.es/m/caaj_b94hancrpvreuub9-qun2ub+gfcox3fg_vx0s6afse+...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/p