pgsql: doc: Add description about re-analysis and re-planning of a prep

2020-11-25 Thread Fujii Masao
doc: Add description about re-analysis and re-planning of a prepared statement. A prepared statement is re-analyzed and re-planned whenever database objects used in the statement have undergone definitional changes or the planner statistics of them have been updated. The former has been documented

pgsql: Use Enums for logical replication message types at more places.

2020-11-25 Thread Amit Kapila
Use Enums for logical replication message types at more places. Commit 644f0d7cc9 added logical replication message type enums to use instead of character literals but some char substitutions were overlooked. Author: Peter Smith Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CAHut+PsTG

pgsql: Avoid spurious waits in concurrent indexing

2020-11-25 Thread Alvaro Herrera
Avoid spurious waits in concurrent indexing In the various waiting phases of CREATE INDEX CONCURRENTLY (CIC) and REINDEX CONCURRENTLY (RC), we wait for other processes to release their snapshots; this is necessary in general for correctness. However, processes doing CIC in other tables cannot pos

pgsql: In psql's \d commands, don't truncate attribute default values.

2020-11-25 Thread Tom Lane
In psql's \d commands, don't truncate attribute default values. Historically, psql has truncated the text of a column's default expression at 128 characters. This is unlike any other behavior in describe.c, and it's become particularly confusing now that the limit is only applied to the expressio

pgsql: In psql's \d commands, don't truncate attribute default values.

2020-11-25 Thread Tom Lane
In psql's \d commands, don't truncate attribute default values. Historically, psql has truncated the text of a column's default expression at 128 characters. This is unlike any other behavior in describe.c, and it's become particularly confusing now that the limit is only applied to the expressio

pgsql: In psql's \d commands, don't truncate attribute default values.

2020-11-25 Thread Tom Lane
In psql's \d commands, don't truncate attribute default values. Historically, psql has truncated the text of a column's default expression at 128 characters. This is unlike any other behavior in describe.c, and it's become particularly confusing now that the limit is only applied to the expressio

pgsql: Doc: minor improvements for section 11.2 "Index Types".

2020-11-25 Thread Tom Lane
Doc: minor improvements for section 11.2 "Index Types". Break the per-index-type discussions into 's so as to make them more visually separate and easier to find. Improve the markup, and make a couple of small wording adjustments. This also fixes one stray reference to the now-deprecated point o

pgsql: Avoid spamming the client with multiple ParameterStatus messages

2020-11-25 Thread Tom Lane
Avoid spamming the client with multiple ParameterStatus messages. Up to now, we sent a ParameterStatus message to the client immediately upon any change in the active value of any GUC_REPORT variable. This was only barely okay when the feature was designed; now that we have things like function S

pgsql: tablefunc: Reject negative number of tuples passed to normal_ran

2020-11-25 Thread Peter Eisentraut
tablefunc: Reject negative number of tuples passed to normal_rand() The function converted the first argument i.e. the number of tuples to return into an unsigned integer which turns out to be huge number when a negative value is passed. This causes the function to take much longer time to execut

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b9a027c53a2a1efbe45413c83fc89412654a0d1c Modified Files -- doc/src/sgml/

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7ef52b5d5de42cdd7d29f6bce7d7a07a9d4c6345 Modified Files -- doc/src/sgml/

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b608645c17d7979357ebdbc9f461bfca54a6a415 Modified Files -- doc/src/sgml/

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2fbd786c3446b1bc90f396d3fa5f4614b0a57d89 Modified Files -- doc/src/sgml/contrib

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/796f57d21697b2a9addfebae9d0182f2539b883e Modified Files -- doc/src/sgml/

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d965f698dcbe05d07ec44ba95db94b9e483c8066 Modified Files -- doc/src/sgml/

pgsql: doc: Fix typos

2020-11-25 Thread Peter Eisentraut
doc: Fix typos Author: Justin Pryzby Discussion: https://www.postgresql.org/message-id/20201121194105.go24...@telsasoft.com Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/272ace098dd365b7aba2dfa93fbf35e1ba55d984 Modified Files -- doc/src/sgml/