Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

Refactor ExecScan() to allow inlining of its core logic
Amit Langote: This commit refactors ExecScan() by moving its tuple-fetching, filtering, and projection logic into an inline-able function, ExecScanExtended(), defined in src/include/executor/execScan.h.

Rework handling of pending data for backend statistics
Michael Paquier: 9aea73fc61d4 has added support for backend statistics, relying on PgStat_EntryRef->pending for its data pending for flush.

Other Activity This Week

Support PG_UNICODE_FAST locale in the builtin collation provider
Jeff Davis: The PG_UNICODE_FAST locale uses code point sort order (fast, memcmp-based) combined with Unicode character semantics.

Support Unicode full case mapping and conversion
Jeff Davis: Generate tables from Unicode SpecialCasing.txt to support more sophisticated case mapping behavior:

Convert libpgport's pqsignal() to a void function
Nathan Bossart: The protections added by commit 3b00fdba9f introduced race conditions to this function that can lead to bogus return values.

Seek zone abbreviations in the IANA data before timezone_abbreviations
Tom Lane: If a time zone abbreviation used in datetime input is defined in the currently active timezone, use that definition in preference to looking in the timezone_abbreviations list.

Add OLD/NEW support to RETURNING in DML queries
Dean Rasheed: This allows the RETURNING list of INSERT/UPDATE/DELETE/MERGE queries to explicitly return old and new values by using the special aliases "old" and "new", which are automatically added to the query (if not already defined) while parsing its RETURNING list, allowing things like: RETURNING old.colname, new.colname, ... RETURNING old.*, new.* Additionally, a new syntax is supported, allowing the names "old" and "new" to be changed to user-supplied alias names, e.g.: RETURNING WITH (OLD AS o, NEW AS n) o.colname, n.colname, ... This is useful when the names "old" and "new" are already defined, such as inside trigger functions, allowing backwards compatibility to be maintained -- the interpretation of any existing queries that happen to already refer to relations called "old" or "new", or use those as aliases for other relations, is not changed. For an INSERT, old values will generally be NULL, and for a DELETE, new values will generally be NULL, but that may change for an INSERT with an ON CONFLICT ...

postgres_fdw: SCRAM authentication pass-through
Peter Eisentraut: This enables SCRAM authentication for postgres_fdw when connecting to a foreign server without having to store a plain-text password on user mapping options. This is done by saving the SCRAM ClientKey and ServeryKey from the client authentication and using those instead of the plain-text password for the server-side SCRAM exchange.

PostgreSQL Release Tags

Support SSL_R_VERSION_TOO_LOW when using LibreSSL
Daniel Gustafsson: The SSL_R_VERSION_TOO_LOW error reason is supported in LibreSSL since LibreSSL 3.6.3, shipped in OpenBSD 7.2.

Log OpenSSL version in ./configure output
Michael Paquier: This information is useful to know when scanning buildfarm results, and it is already displayed in Meson.

meson: Improve PG_VERSION_STR generation
Andres Freund: Previously the host operating system and 32/64 bit were not included and the build machine's cpu was used, which is potentially wrong for cross builds.

Fix ALTER COLLATION "default" REFRESH VERSION.
Jeff Davis: Issue a helpful error message rather than an internal error. Discussion:

Require version 0.98 of Test::More for TAP tests
Andrew Dunstan: This means that the subtest feature will be available for use. We expect that this change will make prairiedog go red until it is updated, but other buildfarm animals should be fine. Discussion:

doc: Fix link reference for PGSSLMAXPROTOCOLVERSION
Michael Paquier: The link was pointing to the minimum protocol version.

nbtree: BTREE_[MIN|NOVAC]_VERSION comment tweaks
Peter Geoghegan: Author: Peter Geoghegan

Automate the maintenance of SO_MINOR_VERSION for our shared libraries
Tom Lane: Up to now we've manually adjusted these numbers in several different Makefiles at the start of each development cycle.

Advance PG_CONTROL_VERSION.
Tom Lane: This should have been done in commit 73c986adde5d73a5 which added several new fields to pg_control, and again in commit 5028f22f6eb05798 which changed the CRC algorithm, but it wasn't.

Tab complete CREATE EXTENSION .. VERSION.
Robert Haas: Jeff Janes

Most Popular In The Past Month

Improve handling of date_trunc() units for infinite input values
Michael Paquier: Previously, if an infinite value was passed to date_trunc(), then the same infinite value would always be returned regardless of the field unit given by the caller.

Add OLD/NEW support to RETURNING in DML queries
Dean Rasheed: This allows the RETURNING list of INSERT/UPDATE/DELETE/MERGE queries to explicitly return old and new values by using the special aliases "old" and "new", which are automatically added to the query (if not already defined) while parsing its RETURNING list, allowing things like: RETURNING old.colname, new.colname, ... RETURNING old.*, new.* Additionally, a new syntax is supported, allowing the names "old" and "new" to be changed to user-supplied alias names, e.g.: RETURNING WITH (OLD AS o, NEW AS n) o.colname, n.colname, ... This is useful when the names "old" and "new" are already defined, such as inside trigger functions, allowing backwards compatibility to be maintained -- the interpretation of any existing queries that happen to already refer to relations called "old" or "new", or use those as aliases for other relations, is not changed. For an INSERT, old values will generally be NULL, and for a DELETE, new values will generally be NULL, but that may change for an INSERT with an ON CONFLICT ...

Support Unicode full case mapping and conversion
Jeff Davis: Generate tables from Unicode SpecialCasing.txt to support more sophisticated case mapping behavior:

psql: Add option to use expanded mode to all list commands
Dean Rasheed: This allows "x" to be appended to any psql list-like meta-command, forcing its output to be displayed in expanded mode.

Support PG_UNICODE_FAST locale in the builtin collation provider
Jeff Davis: The PG_UNICODE_FAST locale uses code point sort order (fast, memcmp-based) combined with Unicode character semantics.

Seek zone abbreviations in the IANA data before timezone_abbreviations
Tom Lane: If a time zone abbreviation used in datetime input is defined in the currently active timezone, use that definition in preference to looking in the timezone_abbreviations list.

postgres_fdw: SCRAM authentication pass-through
Peter Eisentraut: This enables SCRAM authentication for postgres_fdw when connecting to a foreign server without having to store a plain-text password on user mapping options. This is done by saving the SCRAM ClientKey and ServeryKey from the client authentication and using those instead of the plain-text password for the server-side SCRAM exchange.

Remove pgrminclude and associated scripts
Peter Eisentraut: Per git log, the last time someone tried to do something with pgrminclude was around 2011.

ecpg: Restore detection of unsupported COPY FROM STDIN.
Fujii Masao: The ecpg command includes code to warn about unsupported COPY FROM STDIN statements in input files.

Add new StringInfo APIs to allow callers to specify the buffer size
Tatsuo Ishii: Previously StringInfo APIs allocated buffers with fixed initial allocation size of 1024 bytes.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2025 by Phoronix Media. All rights reserved.
All trademarks and copyrights used are properties of their respective owners.
Powered by the Phoronix Content Management System (PHXCMS-8).