pgsql: doc: Fix format, incorrect structure names and markup inconsiste

2020-08-22 Thread Michael Paquier
doc: Fix format, incorrect structure names and markup inconsistencies Author: Alexander Lakhin Discussion: https://postgr.es/m/[email protected] Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/610394c7b876bc8

pgsql: doc: Fix format, incorrect structure names and markup inconsiste

2020-08-22 Thread Michael Paquier
doc: Fix format, incorrect structure names and markup inconsistencies Author: Alexander Lakhin Discussion: https://postgr.es/m/[email protected] Backpatch-through: 13 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c3a288649e152612791121

pgsql: Fix ALTER TABLE's scheduling rules for AT_AddConstraint subcomma

2020-08-22 Thread Tom Lane
Fix ALTER TABLE's scheduling rules for AT_AddConstraint subcommands. Commit 1281a5c90 rearranged the logic in this area rather drastically, and it broke the case of adding a foreign key constraint in the same ALTER that adds the pkey or unique constraint it depends on. While self-referential fkey

pgsql: Fix ALTER TABLE's scheduling rules for AT_AddConstraint subcomma

2020-08-22 Thread Tom Lane
Fix ALTER TABLE's scheduling rules for AT_AddConstraint subcommands. Commit 1281a5c90 rearranged the logic in this area rather drastically, and it broke the case of adding a foreign key constraint in the same ALTER that adds the pkey or unique constraint it depends on. While self-referential fkey

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco

pgsql: Avoid pushing quals down into sub-queries that have grouping set

2020-08-22 Thread Tom Lane
Avoid pushing quals down into sub-queries that have grouping sets. The trouble with doing this is that an apparently-constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets. A qual using such a column would be subject to inco