pgsql: Add missing include dir and references to libpq for MSVC build

2023-10-24 Thread David Rowley
Add missing include dir and references to libpq for MSVC build 66d6086cb adjusted pg_regress to require this but forgot to adjust the Visual Studio build script. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/673a17e31202cc47a9309e9b0b9b5fbec36080d3 Modified Files

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: doc: Fix some typos and grammar

2023-10-24 Thread Michael Paquier
doc: Fix some typos and grammar Author: Ekaterina Kiryanova, Elena Indrupskaya, Oleg Sibiryakov, Maxim Yablokov Discussion: https://postgr.es/m/7aad518b-3e6d-47f3-9184-b1d69cb41...@postgrespro.ru Backpatch-through: 11 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/com

pgsql: Log OpenSSL version in ./configure output

2023-10-24 Thread Michael Paquier
Log OpenSSL version in ./configure output This information is useful to know when scanning buildfarm results, and it is already displayed in Meson. The output of `openssl version` is logged, with the command retrieved from PATH. This depends on c8e4030d1bdd, so backpatch down to 16. Reviewed-by

pgsql: Log OpenSSL version in ./configure output

2023-10-24 Thread Michael Paquier
Log OpenSSL version in ./configure output This information is useful to know when scanning buildfarm results, and it is already displayed in Meson. The output of `openssl version` is logged, with the command retrieved from PATH. This depends on c8e4030d1bdd, so backpatch down to 16. Reviewed-by

Re: pgsql: Doc: document bpchar, clarify relationship of text and varchar.

2023-10-24 Thread Jeff Davis
On Tue, 2023-10-24 at 18:35 -0400, Bruce Momjian wrote: > I liked this patch and adjusted it;  patch attached.  I would like to > apply it to all branches since it provides useful information. Looks good to me. Regards, Jeff Davis

Re: pgsql: Doc: document bpchar, clarify relationship of text and varchar.

2023-10-24 Thread Bruce Momjian
On Fri, Dec 2, 2022 at 01:55:41PM -0800, Jeff Davis wrote: > On Fri, 2022-12-02 at 15:26 -0500, Tom Lane wrote: > > Perhaps; you got specific wording in mind? > > Here's what I came up with. It's kind of its own thing, because it > can't be described as blank-padded. I liked this patch and adjus

pgsql: Reword memory terminology for PQresultMemorySize

2023-10-24 Thread Daniel Gustafsson
Reword memory terminology for PQresultMemorySize Rather than using the generic word "space" we might as well use "memory" since that's precisely what we're dealing with here. This was extracted from a larger patch around terminology changes where the remaining hunks were rejected. Author: Gurjee

pgsql: Speed up pg_regress server readiness testing.

2023-10-24 Thread Daniel Gustafsson
Speed up pg_regress server readiness testing. Instead of connecting to the server with psql to check if it is ready for running tests, this changes pg_regress to use PQPing which avoids performing system() calls which are expensive on some platforms, like Windows. The frequency of tests is also in

pgsql: Fix problems when a plain-inheritance parent table is excluded.

2023-10-24 Thread Tom Lane
Fix problems when a plain-inheritance parent table is excluded. When an UPDATE/DELETE/MERGE's target table is an old-style inheritance tree, it's possible for the parent to get excluded from the plan while some children are not. (I believe this is only possible if we can prove that a CHECK ... NO

pgsql: Fix problems when a plain-inheritance parent table is excluded.

2023-10-24 Thread Tom Lane
Fix problems when a plain-inheritance parent table is excluded. When an UPDATE/DELETE/MERGE's target table is an old-style inheritance tree, it's possible for the parent to get excluded from the plan while some children are not. (I believe this is only possible if we can prove that a CHECK ... NO

pgsql: Fix problems when a plain-inheritance parent table is excluded.

2023-10-24 Thread Tom Lane
Fix problems when a plain-inheritance parent table is excluded. When an UPDATE/DELETE/MERGE's target table is an old-style inheritance tree, it's possible for the parent to get excluded from the plan while some children are not. (I believe this is only possible if we can prove that a CHECK ... NO

pgsql: Fix problems when a plain-inheritance parent table is excluded.

2023-10-24 Thread Tom Lane
Fix problems when a plain-inheritance parent table is excluded. When an UPDATE/DELETE/MERGE's target table is an old-style inheritance tree, it's possible for the parent to get excluded from the plan while some children are not. (I believe this is only possible if we can prove that a CHECK ... NO

pgsql: Doc: indexUnchanged is strictly a hint.

2023-10-24 Thread Peter Geoghegan
Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Pe

pgsql: Doc: indexUnchanged is strictly a hint.

2023-10-24 Thread Peter Geoghegan
Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Pe

pgsql: Doc: indexUnchanged is strictly a hint.

2023-10-24 Thread Peter Geoghegan
Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Pe

pgsql: Doc: indexUnchanged is strictly a hint.

2023-10-24 Thread Peter Geoghegan
Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Pe