- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- psql: Add support for pipelines
- Add support for OAUTHBEARER SASL mechanism
- Transfer statistics during pg_upgrade
- Don't lock partitions pruned by initial pruning
- Add support for LIKE in CREATE FOREIGN TABLE
- makefs(8): Sync cd9660 function with FreeBSD
- Implement Self-Join Elimination
- Linux Kernel: Linux 6.14-rc3
- Latest News (cont.)
- avfilter/scale*: add option reset_sar
- Virtual generated columns
- glibc: Create ChangeLog.old/ChangeLog.30
- Add MetaButton Widget
- Add SQL function CASEFOLD().
- Add support for Unicode case folding
- Support RN (roman-numeral format) in to_number().
- Linux Kernel: Linux 6.13
- [bdf] Tokenize input instead of listing
- Support Unicode full case mapping and conversion
- Add OLD/NEW support to RETURNING in DML queries
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Yesterday's Activity
- Avoid race condition between "GRANT role" and "DROP ROLE".
Tom Lane: Concurrently dropping either the granted role or the grantee does not stop GRANT from completing, instead resulting in a dangling role reference in pg_auth_members. - pg_upgrade: Add --set-char-signedness to set the default char signedness of new cluster
Masahiko Sawada: This change adds a new option --set-char-signedness to pg_upgrade. - pg_resetwal: Add --char-signedness option to change the default char signedness
Masahiko Sawada: With the newly added option --char-signedness, pg_resetwal updates the default char signedness flag in the controlfile. - doc: Add links to olsen93 and ong90 in bibliography
Daniel Gustafsson: The bibliography entries for olsen93 and ong90 lacked links to online copies. - psql: Add support for pipelines
Michael Paquier: With \bind, \parse, \bind_named and \close, it is possible to issue queries from psql using the extended protocol.
Other Activity This Week
- Trial fix for old cross-version upgrades
Jeff Davis: Per buildfarm and reports, it seems that 9.X to 18 upgrades were failing after commit 1fd1bd8710 due to an incorrect regex. - cirrus: Temporarily fix libcurl link error
Daniel Gustafsson: On FreeBSD the ftp/curl port appears to be missing a minimum - Add support for OAUTHBEARER SASL mechanism
Daniel Gustafsson: This commit implements OAUTHBEARER, RFC 7628, and OAuth 2.0 Device Authorization Grants, RFC 8628. - Transfer statistics during pg_upgrade
Jeff Davis: Add support to pg_dump for dumping stats, and use that during pg_upgrade so that statistics are transferred during upgrade. - Don't lock partitions pruned by initial pruning
Amit Langote: Before executing a cached generic plan, AcquireExecutorLocks() in plancache.c locks all relations in a plan's range table to ensure the plan is safe for execution. - Fix FATAL message for invalid recovery timeline at beginning of recovery
Michael Paquier: If the requested recovery timeline is not reachable, the logged checkpoint and timeline should to be the values read from the backup_label when it is defined. - Fix crash in brininsertcleanup during logical replication
Tom Lane: Logical replication crashes if the subscriber's partitioned table has a BRIN index. - Consider BufFiles when adjusting hashjoin parameters
Tomas Vondra: Until now ExecChooseHashTableSize() considered only the size of the in-memory hash table, and ignored the memory needed for the batch files. - Add support for LIKE in CREATE FOREIGN TABLE
Michael Paquier: LIKE enables the creation of foreign tables based on the column definitions, constraints and objects of the defined source relation(s). This feature mirrors the behavior of CREATE TABLE LIKE, but ignores the INCLUDING sub-options that do not make sense for foreign tables: INDEXES, COMPRESSION, IDENTITY and STORAGE. - Invalidate inactive replication slots
Amit Kapila: This commit introduces idle_replication_slot_timeout GUC that allows inactive slots to be invalidated at the time of checkpoint. - Update to latest Snowball sources
Tom Lane: It's been some time since we did this, partly because the upstream snowball project hasn't formally tagged a new release since 2021. - doc: add example of sign mismatch with POSIX/ISO-8601 time zones
Bruce Momjian: Author: Laurenz Albe - Add PGErrorVerbosity to typedefs.list
Daniel Gustafsson: PGErrorVerbosity was missing which resulted in incorrect whitespace alignment going back all the way to e3860ffa4dd0. - Add tab completion for ALTER USER/ROLE RESET
Tomas Vondra: Currently tab completion for ALTER USER RESET shows a list of all configuration parameters that may be set on a role, irrespectively of which parameters are actually set. - Add tab completion for ALTER DATABASE RESET
Tomas Vondra: Currently tab completion for ALTER DATABASE RESET shows a list of all configuration parameters that may be set on a database, irrespectively of which parameters are actually set. - Implement Self-Join Elimination
Alexander Korotkov: The Self-Join Elimination (SJE) feature removes an inner join of a plain table to itself in the query tree if it is proven that the join can be replaced with a scan without impacting the query result. - Fix an oversight in cbc127917 to handle MERGE correctly
Amit Langote: ExecInitModifyTable() forgot to trim MERGE-related lists to exclude entries for result relations pruned during initial pruning, so fix that. - Add information about WAL buffers full to VACUUM/ANALYZE (VERBOSE)
Michael Paquier: This commit adds the information about the number of times WAL buffers have been full to the logs generated by VACUUM/ANALYZE (VERBOSE) and in the logs generated by autovacuum, complementing the existing information stored by WalUsage. This is the last part of the backend code where the value of wal_buffers_full can be reported, similarly to all the other fields of WalUsage. - Add information about WAL buffers being full to EXPLAIN (WAL)
Michael Paquier: This is similar to ce5bcc4a9f26, relying on the addition of wal_buffers_full to WalUsage.
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
- Avoid breaking SJIS encoding while de-backslashing Windows paths
Tom Lane: When running on Windows, canonicalize_path() converts '\' to '/' to prevent confusing the Windows command processor. - Add support for OAUTHBEARER SASL mechanism
Daniel Gustafsson: This commit implements OAUTHBEARER, RFC 7628, and OAuth 2.0 Device Authorization Grants, RFC 8628. - Implement Self-Join Elimination
Alexander Korotkov: The Self-Join Elimination (SJE) feature removes an inner join of a plain table to itself in the query tree if it is proven that the join can be replaced with a scan without impacting the query result. - Virtual generated columns
Peter Eisentraut: This adds a new variant of generated columns that are computed on read (like a view, unlike the existing stored generated columns, which are computed on write, like a materialized view). The syntax for the column definition is ... - psql: Add support for pipelines
Michael Paquier: With \bind, \parse, \bind_named and \close, it is possible to issue queries from psql using the extended protocol. - Don't lock partitions pruned by initial pruning
Amit Langote: Before executing a cached generic plan, AcquireExecutorLocks() in plancache.c locks all relations in a plan's range table to ensure the plan is safe for execution. - Add support for LIKE in CREATE FOREIGN TABLE
Michael Paquier: LIKE enables the creation of foreign tables based on the column definitions, constraints and objects of the defined source relation(s). This feature mirrors the behavior of CREATE TABLE LIKE, but ignores the INCLUDING sub-options that do not make sense for foreign tables: INDEXES, COMPRESSION, IDENTITY and STORAGE. - pgcrypto: Add support for CFB mode in AES encryption
Daniel Gustafsson: Cipher Feedback Mode, CFB, is a self-synchronizing stream cipher which is very similar to CBC performed in reverse. - Add support for Unicode case folding
Jeff Davis: Expand case mapping tables to include entries for case folding, which are parsed from CaseFolding.txt. - Remove support for linking with libeay32 and ssleay32
Daniel Gustafsson: The OpenSSL project stopped using the eay names back in 2016 on platforms other than Microsoft Windows, and version 1.1.0 removed the names from Windows as well.