Search Results for: WAITING FOR POSTGRESQL 10

Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression

On 4th of January 2024, Peter Eisentraut committed patch: ALTER TABLE command to change generation expression   This adds a new ALTER TABLE subcommand ALTER COLUMN … SET EXPRESSION that changes the generation expression of a generated column.   The syntax is not standard but was adapted from other SQL implementations.   This command causes … Continue reading “Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression”

Waiting for PostgreSQL 17 – Add support for incremental backup.

On 20th of December 2023, Robert Haas committed patch: Add support for incremental backup.   To take an incremental backup, you use the new replication command UPLOAD_MANIFEST to upload the manifest for the prior backup. This prior backup could either be a full backup or another incremental backup. You then use BASE_BACKUP with the INCREMENTAL … Continue reading “Waiting for PostgreSQL 17 – Add support for incremental backup.”

Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned

On 29th of August 2023, Daniel Gustafsson committed patch: Allow \watch queries to stop on minimum rows returned   When running a repeat query with \watch in psql, it can be helpful to be able to stop the watch process when the query no longer returns the expected amount of rows. An example would be … Continue reading “Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned”

Waiting for PostgreSQL 17 – Add to_bin() and to_oct().

On 23rd of August 2023, Nathan Bossart committed patch: Add to_bin() and to_oct().   This commit introduces functions for converting numbers to their equivalent binary and octal representations. Also, the base conversion code for these functions and to_hex() has been moved to a common helper function.   Co-authored-by: Eric Radman Reviewed-by: Ian Barwick, Dag Lem, … Continue reading “Waiting for PostgreSQL 17 – Add to_bin() and to_oct().”

Waiting for PostgreSQL 16 – Add array_sample() and array_shuffle() functions.

On 7th of April 2023, Tom Lane committed patch: Add array_sample() and array_shuffle() functions.   These are useful in Monte Carlo applications.   Martin Kalcher, reviewed/adjusted by Daniel Gustafsson and myself   Discussion: https://postgr.es/m/9d160a44-7675-51e8-60cf-6d64b76db831@aboutsource.net

Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics

On 11st of February 2023, Andres Freund committed patch: Add pg_stat_io view, providing more detailed IO statistics   Builds on 28e626bde00 and f30d62c2fc6. See the former for motivation.   Rows of the view show IO operations for a particular backend type, IO target object, IO context combination (e.g. a client backend’s operations on permanent relations … Continue reading “Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics”

Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.

On 4th of February 2023, Dean Rasheed committed patch: Allow underscores in integer and numeric constants.   This allows underscores to be used in integer and numeric literals, and their corresponding type input functions, for visual grouping. For example:   1_500_000_000 3.14159_26535_89793 0xffff_ffff 0b_1001_0001   A single underscore is allowed between any 2 digits, or … Continue reading “Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.”

Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers.

On 9th of January 2023, Tom Lane committed patch: Invent random_normal() to provide normally-distributed random numbers.   There is already a version of this in contrib/tablefunc, but it seems sufficiently widely useful to justify having it in core.   Paul Ramsey   Discussion: https://postgr.es/m/CACowWR0DqHAvOKUCNxTrASFkWsDLqKMd6WiXvVvaWg4pV1BMnQ@mail.gmail.com

Waiting for PostgreSQL 16 – Non-decimal integer literals

On 14th of December 2022, Peter Eisentraut committed patch: Non-decimal integer literals   Add support for hexadecimal, octal, and binary integer literals:   0x42F 0o273 0b100101   per SQL:202x draft.   This adds support in the lexer as well as in the integer type input functions.   Reviewed-by: John Naylor <john.naylor@enterprisedb.com> Reviewed-by: Zhihong Yu <zyu@yugabyte.com> … Continue reading “Waiting for PostgreSQL 16 – Non-decimal integer literals”