Re: pgsql: SQL-standard function body

On Fri, 2021-04-09 at 19:44 +0200, I wrote: > > SQL-standard function body > > > > psql needs some new intelligence to keep track of function body > > boundaries so that it doesn't send off statements when it sees > > semicolons that are inside a function body. > > This causes psql to fail to rec

pgsql: doc: Fix man page whitespace issues

doc: Fix man page whitespace issues Whitespace between tags is significant, and in some cases it creates extra vertical space in man pages. The fix is to remove some newlines in the markup. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9cae39b8e6a53decb37cce22852

pgsql: Suppress length of Notice/Error msgs in PQtrace regress mode

Suppress length of Notice/Error msgs in PQtrace regress mode A (relatively minor) annoyance of ErrorResponse/NoticeResponse messages as printed by PQtrace() is that their length might vary when we move error messages from one source file to another, one function to another, or even when their loca

pgsql: Make new GUC short descriptions more consistent.

Make new GUC short descriptions more consistent. Reported-by: Daniel Westermann (DWE) Discussion: https://postgr.es/m/GV0P278MB0483490FEAC879DCA5ED583DD2739%40GV0P278MB0483.CHEP278.PROD.OUTLOOK.COM Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/846d35b2dc1bd4d09f

pgsql: Doc: Review for "Optionally prefetch referenced data in recovery

Doc: Review for "Optionally prefetch referenced data in recovery." Typos, corrections and language improvements in the docs, and a few in code comments too. Reported-by: Justin Pryzby Discussion: https://postgr.es/m/20210409033703.GP6592%40telsasoft.com Branch -- master Details --- htt

pgsql: doc: Additional documentation for date_bin

doc: Additional documentation for date_bin Reported-by: Justin Pryzby Author: John Naylor Discussion: https://www.postgresql.org/message-id/cafbsxseem1nuhzmfvqxvu_i3nddeuvnj_wmrdo9whfd_jus...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/49fb4e6b

Re: pgsql: SQL-standard function body

On Wed, 2021-04-07 at 19:53 +, Peter Eisentraut wrote: > SQL-standard function body > > This adds support for writing CREATE FUNCTION and CREATE PROCEDURE > statements for language SQL with a function body that conforms to the > SQL standard and is portable to other implementations. > > [...]

pgsql: Document ANALYZE storage parameters for partitioned tables

Document ANALYZE storage parameters for partitioned tables Commit 0827e8af70f4 added parameters for autovacuum to support partitioned tables, but didn't add any docs. Add them. Discussion: https://postgr.es/m/20210408213051.gl6...@telsasoft.com Branch -- master Details --- https://git.

pgsql: Set pg_class.reltuples for partitioned tables

Set pg_class.reltuples for partitioned tables When commit 0827e8af70f4 added auto-analyze support for partitioned tables, it included code to obtain reltuples for the partitioned table as a number of catalog accesses to read pg_class.reltuples for each partition. That's not only very inefficient,

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/721b3a3a9368c0bd5e9b92892279f0fa441efeee

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c777a1fcc6ba1d61bbb763f6fbd3ac8a5994446d

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/19b28d69128a7ca78705be9f4afca5044541beca

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/91a3a7dc63e8fded60b41cd842eba9a8e31f2b5d

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2bf44fbe271dae3f4bd458e19e32d51996b988b4

pgsql: Fix typo

Fix typo Author: Daniel Westermann Backpatch-through: 9.6 Discussion: https://postgr.es/m/gv0p278mb0483a7aa85bafcc06d90f453d2...@gv0p278mb0483.chep278.prod.outlook.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1798d8f8b6fbb8ff922f640ff2d5dbd3e47064a2 Modifie