pgsql: Fix XML id to match GUC name

2020-09-29 Thread Peter Eisentraut
Fix XML id to match GUC name For some reason, the id of the description of max_parallel_maintenance_workers has been guc-max-parallel-workers-maintenance since the beginning. Flip that around to make it consistent. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/30

pgsql: Doc: Improve clarity on partitioned table limitations

2020-09-29 Thread David Rowley
Doc: Improve clarity on partitioned table limitations Explicitly mention that primary key constraints are also included in the limitation that the constraint columns must be a superset of the partition key columns. Wording suggestion from Tom Lane. Discussion: https://postgr.es/m/64062533.78364.

pgsql: Doc: Improve clarity on partitioned table limitations

2020-09-29 Thread David Rowley
Doc: Improve clarity on partitioned table limitations Explicitly mention that primary key constraints are also included in the limitation that the constraint columns must be a superset of the partition key columns. Wording suggestion from Tom Lane. Discussion: https://postgr.es/m/64062533.78364.

pgsql: Remove obsolete replication settings within TAP tests.

2020-09-29 Thread Tom Lane
Remove obsolete replication settings within TAP tests. PostgresNode.pm set "max_wal_senders = 5" for replication testing, but this seems to be slightly too low for our current test suite. Slower buildfarm members frequently report "number of requested standby connections exceeds max_wal_senders" f

pgsql: Remove obsolete replication settings within TAP tests.

2020-09-29 Thread Tom Lane
Remove obsolete replication settings within TAP tests. PostgresNode.pm set "max_wal_senders = 5" for replication testing, but this seems to be slightly too low for our current test suite. Slower buildfarm members frequently report "number of requested standby connections exceeds max_wal_senders" f

pgsql: Remove obsolete replication settings within TAP tests.

2020-09-29 Thread Tom Lane
Remove obsolete replication settings within TAP tests. PostgresNode.pm set "max_wal_senders = 5" for replication testing, but this seems to be slightly too low for our current test suite. Slower buildfarm members frequently report "number of requested standby connections exceeds max_wal_senders" f

pgsql: Remove obsolete replication settings within TAP tests.

2020-09-29 Thread Tom Lane
Remove obsolete replication settings within TAP tests. PostgresNode.pm set "max_wal_senders = 5" for replication testing, but this seems to be slightly too low for our current test suite. Slower buildfarm members frequently report "number of requested standby connections exceeds max_wal_senders" f

pgsql: Remove obsolete replication settings within TAP tests.

2020-09-29 Thread Tom Lane
Remove obsolete replication settings within TAP tests. PostgresNode.pm set "max_wal_senders = 5" for replication testing, but this seems to be slightly too low for our current test suite. Slower buildfarm members frequently report "number of requested standby connections exceeds max_wal_senders" f

pgsql: Doc: Improve clarity on partitioned table limitations

2020-09-29 Thread David Rowley
Doc: Improve clarity on partitioned table limitations Explicitly mention that primary key constraints are also included in the limitation that the constraint columns must be a superset of the partition key columns. Wording suggestion from Tom Lane. Discussion: https://postgr.es/m/64062533.78364.

pgsql: Doc: Improve clarity on partitioned table limitations

2020-09-29 Thread David Rowley
Doc: Improve clarity on partitioned table limitations Explicitly mention that primary key constraints are also included in the limitation that the constraint columns must be a superset of the partition key columns. Wording suggestion from Tom Lane. Discussion: https://postgr.es/m/64062533.78364.

pgsql: Fix make_timestamp[tz] to accept negative years as meaning BC.

2020-09-29 Thread Tom Lane
Fix make_timestamp[tz] to accept negative years as meaning BC. Previously we threw an error. But make_date already allowed the case, so it is inconsistent as well as unhelpful for make_timestamp not to. Both functions continue to reject year zero. Code and test fixes by Peter Eisentraut, doc ch

pgsql: Fix memory leak in plpgsql's CALL processing.

2020-09-29 Thread Tom Lane
Fix memory leak in plpgsql's CALL processing. When executing a CALL or DO in a non-atomic context (i.e., not inside a function or query), plpgsql creates a new plan each time through, as a rather hacky solution to some resource management issues. But it failed to free this plan until exit of the

pgsql: Fix memory leak in plpgsql's CALL processing.

2020-09-29 Thread Tom Lane
Fix memory leak in plpgsql's CALL processing. When executing a CALL or DO in a non-atomic context (i.e., not inside a function or query), plpgsql creates a new plan each time through, as a rather hacky solution to some resource management issues. But it failed to free this plan until exit of the

pgsql: Fix memory leak in plpgsql's CALL processing.

2020-09-29 Thread Tom Lane
Fix memory leak in plpgsql's CALL processing. When executing a CALL or DO in a non-atomic context (i.e., not inside a function or query), plpgsql creates a new plan each time through, as a rather hacky solution to some resource management issues. But it failed to free this plan until exit of the

pgsql: Fix memory leak in plpgsql's CALL processing.

2020-09-29 Thread Tom Lane
Fix memory leak in plpgsql's CALL processing. When executing a CALL or DO in a non-atomic context (i.e., not inside a function or query), plpgsql creates a new plan each time through, as a rather hacky solution to some resource management issues. But it failed to free this plan until exit of the

pgsql: Support for ISO 8601 in the jsonpath .datetime() method

2020-09-29 Thread Alexander Korotkov
Support for ISO 8601 in the jsonpath .datetime() method The SQL standard doesn't require jsonpath .datetime() method to support the ISO 8601 format. But our to_json[b]() functions convert timestamps to text in the ISO 8601 format in the sake of compatibility with javascript. So, we add support o

pgsql: Remove excess space from jsonpath .datetime() default format str

2020-09-29 Thread Alexander Korotkov
Remove excess space from jsonpath .datetime() default format string bffe1bd684 has introduced jsonpath .datetime() method, but default formats for time and timestamp contain excess space between time and timezone. This commit removes this excess space making behavior of .datetime() method standar

pgsql: Remove excess space from jsonpath .datetime() default format str

2020-09-29 Thread Alexander Korotkov
Remove excess space from jsonpath .datetime() default format string bffe1bd684 has introduced jsonpath .datetime() method, but default formats for time and timestamp contain excess space between time and timezone. This commit removes this excess space making behavior of .datetime() method standar

pgsql: Support for ISO 8601 in the jsonpath .datetime() method

2020-09-29 Thread Alexander Korotkov
Support for ISO 8601 in the jsonpath .datetime() method The SQL standard doesn't require jsonpath .datetime() method to support the ISO 8601 format. But our to_json[b]() functions convert timestamps to text in the ISO 8601 format in the sake of compatibility with javascript. So, we add support o

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because

pgsql: Archive timeline history files in standby if archive_mode is set

2020-09-29 Thread Fujii Masao
Archive timeline history files in standby if archive_mode is set to "always". Previously the standby server didn't archive timeline history files streamed from the primary even when archive_mode is set to "always", while it archives the streamed WAL files. This could cause the PITR to fail because