pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Doc: document permissions required for ANALYZE.

2019-08-07 Thread Tom Lane
Doc: document permissions required for ANALYZE. VACUUM's reference page had this text, but ANALYZE's didn't. That's a clear oversight given that section 5.7 explicitly delegates the responsibility to define permissions requirements to the individual commands' man pages. Per gripe from Isaac Morl

pgsql: Remove unnecessary #include

2019-08-07 Thread Alvaro Herrera
Remove unnecessary #include This include was probably copied from tuplestore.c, but it's not needed. Extracted from a larger patch submitted by vignesh C Discussion: https://postgr.es/m/CALDaNm1B9naPDTm3ox1m_yZvOm3KA5S4kZQSWWAeLHAQ=3g...@mail.gmail.com Branch -- master Details --- h

pgsql: Add comment on no default partition with hash partitioning

2019-08-07 Thread Alvaro Herrera
Add comment on no default partition with hash partitioning Discussion: https://postgr.es/m/20190806222735.GA9535@alvherre.pgsql Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/12afc7145c03c212f26fea3a99e016da6a1c919c Modified Files -- src/backend/parser

pgsql: Apply constraint exclusion more generally in partitioning

2019-08-07 Thread Alvaro Herrera
Apply constraint exclusion more generally in partitioning We were applying constraint exclusion on the partition constraint when generating pruning steps for a clause, but only for the rather restricted situation of them being boolean OR operators; however it is possible to have differently shaped

pgsql: Fix some typos in jsonpath documentation

2019-08-07 Thread Alexander Korotkov
Fix some typos in jsonpath documentation Discussion: https://postgr.es/m/8B7FA3B4-328D-43D7-95A8-37B8891B8C78%40winand.at Author: Markus Winand Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/53d467246589de631ce1846105f990099219e737 Mod

pgsql: Fix some typos in jsonpath documentation

2019-08-07 Thread Alexander Korotkov
Fix some typos in jsonpath documentation Discussion: https://postgr.es/m/8B7FA3B4-328D-43D7-95A8-37B8891B8C78%40winand.at Author: Markus Winand Backpatch-through: 12 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1f33f211bc531d257f84fefb9208dd43e8718972 Modified F

pgsql: Fix typo in comment.

2019-08-07 Thread Etsuro Fujita
Fix typo in comment. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/26555cbd6e1443ea783717fd49b2ca1d55e4a015 Modified Files -- src/backend/utils/cache/partcache.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix typo in comment.

2019-08-07 Thread Etsuro Fujita
Fix typo in comment. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/dcebb3e9c7cf7836779a82fcc202af9b5266a893 Modified Files -- src/backend/catalog/partition.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix typos in comments.

2019-08-07 Thread Etsuro Fujita
Fix typos in comments. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/68343b4ad75305391b38f4b42734dc07f2fe7ee2 Modified Files -- src/backend/partitioning/partbounds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

pgsql: Fix typos in comments.

2019-08-07 Thread Etsuro Fujita
Fix typos in comments. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ca8a57b6369322b5ffd915c130da5e902d7f970c Modified Files -- src/backend/partitioning/partbounds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix predicate-locking of HOT updated rows.

2019-08-07 Thread Heikki Linnakangas
Fix predicate-locking of HOT updated rows. In serializable mode, heap_hot_search_buffer() incorrectly acquired a predicate lock on the root tuple, not the returned tuple that satisfied the visibility checks. As explained in README-SSI, the predicate lock does not need to be copied or extended to o

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu

pgsql: Fix some incorrect parsing of time with time zone strings

2019-08-07 Thread Michael Paquier
Fix some incorrect parsing of time with time zone strings When parsing a timetz string with a dynamic timezone abbreviation or a timezone not specified, it was possible to generate incorrect timestamps based on a date which uses some non-initialized variables if the input string did not specify fu