pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: doc: Fix section of functions age(xid) and mxid_age(xid)

2024-11-19 Thread Michael Paquier
doc: Fix section of functions age(xid) and mxid_age(xid) In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based on the discussion that led to 48b5aa3143, this is not intentional as this could break many existing monitoring queries. Note that vacuumdb also uses both of them. In 16,

pgsql: doc: Fix section of functions age(xid) and mxid_age(xid)

2024-11-19 Thread Michael Paquier
doc: Fix section of functions age(xid) and mxid_age(xid) In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based on the discussion that led to 48b5aa3143, this is not intentional as this could break many existing monitoring queries. Note that vacuumdb also uses both of them. In 16,

pgsql: doc: Fix section of functions age(xid) and mxid_age(xid)

2024-11-19 Thread Michael Paquier
doc: Fix section of functions age(xid) and mxid_age(xid) In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based on the discussion that led to 48b5aa3143, this is not intentional as this could break many existing monitoring queries. Note that vacuumdb also uses both of them. In 16,

pgsql: Tag refs/tags/REL_16_6 was created

2024-11-19 Thread noreply
Tag refs/tags/REL_16_6 was created.

pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: Compare collations before merging UNION operations.

2024-11-19 Thread Tom Lane
Compare collations before merging UNION operations. In the dim past we figured it was okay to ignore collations when combining UNION set-operation nodes into a single N-way UNION operation. I believe that was fine at the time, but it stopped being fine when we added nondeterministic collations: t

pgsql: Tag refs/tags/REL_17_2 was created

2024-11-19 Thread noreply
Tag refs/tags/REL_17_2 was created.

pgsql: Tag refs/tags/REL_12_22 was created

2024-11-19 Thread noreply
Tag refs/tags/REL_12_22 was created.

pgsql: Improve error message for database object stats manipulation fun

2024-11-19 Thread Fujii Masao
Improve error message for database object stats manipulation functions. Previously, database object statistics manipulation functions like pg_set_relation_stats() reported unclear error and hint messages when executed during recovery. These messages were "internal", making it difficult for users t