On 8th of April 2025, Daniel Gustafsson committed patch:| select * from depesz;
On 7th of April 2025, Álvaro Herrera committed patch: Allow NOT NULL constraints to be added as NOT VALID This allows them to be added without scanning the table, and validating them afterwards without holding access exclusive lock on the table after any violating rows have been deleted or fixed. Doing ALTER TABLE … Continue reading "Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID"| select * from depesz;
On 5th of April 2025, Álvaro Herrera committed patch: Add modern SHA-2 based password hashes to pgcrypto. This adapts the publicly available reference implementation on https://www.akkadia.org/drepper/SHA-crypt.txt and adds the new hash algorithms sha256crypt and sha512crypt to crypt() and gen_salt() respectively. Author: Bernd Helmle <mailings@oopsware.de> Reviewed-by: Japin Li <japinli@hotmail.com> Discussion: https://postgr.es/m/c763235a2757e2f5f9e3e27268b9028349cef659.camel@oopswar...| select * from depesz;
On 4th of April 2025, Andrew Dunstan committed patch: Non text modes for pg_dumpall, correspondingly change pg_restore pg_dumpall acquires a new -F/--format option, with the same meanings as pg_dump. The default is p, meaning plain text. For any other value, a directory is created containing two files, globals.data and map.dat. The first contains SQL … Continue reading "Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore"| select * from depesz;
On 5th of March 2025, Andrew Dunstan committed patch: Allow json{b}_strip_nulls to remove null array elements An additional paramater ("strip_in_arrays") is added to these functions. It defaults to false. If true, then null array elements are removed as well as null valued object fields. JSON that just consists of a single null is not … Continue reading "Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements"| select * from depesz;
On 11st of December 2024, Masahiko Sawada committed patch: Add UUID version 7 generation function. This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. UUIDv7 combines a Unix timestamp in milliseconds and random bits, offering both uniqueness and sortability. In our implementation, the 12-bit sub-millisecond … Continue reading "Waiting for PostgreSQL 18 – Add UUID version 7 generation function."| select * from depesz;
On 1st of November 2024, Michael Paquier committed patch: Add SQL function array_reverse() This function takes in input an array, and reverses the position of all its elements. This operation only affects the first dimension of the array, like array_shuffle(). The implementation structure is inspired by array_shuffle(), with a subroutine called array_reverse_n() that … Continue reading "Waiting for PostgreSQL 18 – Add SQL function array_reverse()"| select * from depesz;
On 3rd of March 2025, Tomas Vondra committed patch:| select * from depesz;
On 21st of February 2025, Robert Haas committed patch:| select * from depesz;
On 7th of February 2025, Peter Eisentraut committed patch:| select * from depesz;
On 14th of February 2025, Nathan Bossart committed patch:| select * from depesz;
On 11st of February 2025, Nathan Bossart committed patch:| select * from depesz;
On 22nd of January 2025, Tom Lane committed patch:| select * from depesz;
On 16th of January 2025, Dean Rasheed committed patch:| select * from depesz;
On 6th of January 2025, Nathan Bossart committed patch:| select * from depesz;
On 11st of December 2024, David Rowley committed patch:| select * from depesz;
On 27th of November 2024, Peter Eisentraut committed patch:| select * from depesz;
On 18th of December 2024, Michael Paquier committed patch:| select * from depesz;