pgsql: Add pg_dump test for triggers on partitioned tables

2019-12-27 Thread Alvaro Herrera
Add pg_dump test for triggers on partitioned tables This currently works, but add this test to ensure it continues to work. Lack of this test became evident after a recent bugfix submission that would have inadvertently broken it, in https://postgr.es/m/CA+HiwqFM2=i+uhb9o4oklbe2s3sjphove2wxuad1glj

pgsql: Add pg_dump test for triggers on partitioned tables

2019-12-27 Thread Alvaro Herrera
Add pg_dump test for triggers on partitioned tables This currently works, but add this test to ensure it continues to work. Lack of this test became evident after a recent bugfix submission that would have inadvertently broken it, in https://postgr.es/m/CA+HiwqFM2=i+uhb9o4oklbe2s3sjphove2wxuad1glj

pgsql: Add pg_dump test for triggers on partitioned tables

2019-12-27 Thread Alvaro Herrera
Add pg_dump test for triggers on partitioned tables This currently works, but add this test to ensure it continues to work. Lack of this test became evident after a recent bugfix submission that would have inadvertently broken it, in https://postgr.es/m/CA+HiwqFM2=i+uhb9o4oklbe2s3sjphove2wxuad1glj

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
doc: add examples of creative use of unique expression indexes Unique expression indexes can constrain data in creative ways, so show two examples. Reported-by: Tuomas Leikola Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_5_STABLE Details --- https:/

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- master Details --- https://git.po

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_11_STABLE Details --- https:/

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_4_STABLE Details --- https:/

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_12_STABLE Details --- https:/

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_10_STABLE Details --- https:/

pgsql: docs: clarify infinite range values from data-type infinities

2019-12-27 Thread Bruce Momjian
docs: clarify infinite range values from data-type infinities The previous docs referenced these distinct ideas confusingly. Reported-by: Eugen Konkov Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_6_STABLE Details --- https:/

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.

pgsql: Forbid DROP SCHEMA on temporary namespaces

2019-12-27 Thread Michael Paquier
Forbid DROP SCHEMA on temporary namespaces This operation was possible for the owner of the schema or a superuser. Down to 9.4, doing this operation would cause inconsistencies in a session whose temporary schema was dropped, particularly if trying to create new temporary objects after the drop.