Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

Improve isolationtester's timeout management
Tom Lane: isolationtester.c had a hard-wired limit of 3 minutes per test step.

Yesterday's Activity

Document search_path security with untrusted dbowner or CREATEROLE.
Noah Misch: Commit 5770172cb0c9df9e6ce27c507b449557e5b45124 wrote, incorrectly, that certain schema usage patterns are secure against CREATEROLE users and database owners.

Other Activity This Week

Disallow non-default collation in ADD PRIMARY KEY/UNIQUE USING INDEX.
Tom Lane: When creating a uniqueness constraint using a pre-existing index, we have always required that the index have the same properties you'd get if you just let a new index get built.

Fix handling of OpenSSL's SSL_clear_options
Michael Paquier: This function is supported down to OpenSSL 0.9.8, which is the oldest version supported since 593d4e4 (from Postgres 10 onwards), and is used since e3bdb2d (from 11 onwards).

Update minimum SSL version
Peter Eisentraut: Change default of ssl_min_protocol_version to TLSv1.2 (from TLSv1, which means 1.0).

Fix EXPLAIN's column alias output for mismatched child tables
Tom Lane: If an inheritance/partitioning parent table is assigned some column alias names in the query, EXPLAIN mapped those aliases onto the child tables' columns by physical position, resulting in bogus output if a child table's columns aren't one-for-one with the parent's. To fix, make expand_single_inheritance_child() generate a correctly re-mapped column alias list, rather than just copying the parent RTE's alias node.

Recent Activity

Improve isolationtester's timeout management
Tom Lane: isolationtester.c had a hard-wired limit of 3 minutes per test step.

Document search_path security with untrusted dbowner or CREATEROLE.
Noah Misch: Commit 5770172cb0c9df9e6ce27c507b449557e5b45124 wrote, incorrectly, that certain schema usage patterns are secure against CREATEROLE users and database owners.

Disallow non-default collation in ADD PRIMARY KEY/UNIQUE USING INDEX.
Tom Lane: When creating a uniqueness constraint using a pre-existing index, we have always required that the index have the same properties you'd get if you just let a new index get built.

Fix handling of OpenSSL's SSL_clear_options
Michael Paquier: This function is supported down to OpenSSL 0.9.8, which is the oldest version supported since 593d4e4 (from Postgres 10 onwards), and is used since e3bdb2d (from 11 onwards).

Update minimum SSL version
Peter Eisentraut: Change default of ssl_min_protocol_version to TLSv1.2 (from TLSv1, which means 1.0).

Fix EXPLAIN's column alias output for mismatched child tables
Tom Lane: If an inheritance/partitioning parent table is assigned some column alias names in the query, EXPLAIN mapped those aliases onto the child tables' columns by physical position, resulting in bogus output if a child table's columns aren't one-for-one with the parent's. To fix, make expand_single_inheritance_child() generate a correctly re-mapped column alias list, rather than just copying the parent RTE's alias node.

Add query cancellation capabilities in pgbench init phase
Michael Paquier: This can be useful to stop data generation happening on the server for long-running queries caused by large scale factors.

Fix misbehavior with expression indexes on ON COMMIT DELETE ROWS tables
Tom Lane: We implement ON COMMIT DELETE ROWS by truncating tables marked that way, which requires also truncating/rebuilding their indexes.

libq support for sslpassword connection param, DER format keys
Andrew Dunstan: This patch providies for support for password protected SSL client keys in libpq, and for DER format keys, both encrypted and unencrypted.

pg_upgrade: improve instructions for fixing incompatible isn use
Bruce Momjian: This clarifies instructions on how to dump/reload databases that use incompatible isn versions.

PostgreSQL Release Tags

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

Bump PG_CONTROL_VERSION for previous 9.4 changes
Tom Lane: This should have been done in 6bc8ef0b7f1f1df3998745a66e1790e27424aa0c and/or 50e547096c4858a68abf09894667a542cc418315, but better late than never.

Most Popular In The Past Month

Make the order of the header file includes consistent in backend modules
Amit Kapila: Similar to commits 7e735035f2 and dddf4cdc33, this commit makes the order of header file inclusion consistent for backend modules.

Fix page modification outside of critical section in GIN
Alexander Korotkov: By oversight 52ac6cd2d0 makes ginDeletePage() sets pd_prune_xid of page to be deleted before entering the critical section.

Revise GIN README
Alexander Korotkov: We find GIN concurrency bugs from time to time.

Remove configure --disable-float4-byval
Peter Eisentraut: This build option was only useful to maintain compatibility for

Update sepgsql to add mandatory access control for TRUNCATE
Joe Conway: Use SELinux "db_table: { truncate }" to check if permission is granted to TRUNCATE.

Allow ALTER VIEW command to rename the column in the view
Fujii Masao: ALTER TABLE RENAME COLUMN command always can be used to rename the column in the view, but it's reasonable to add that syntax to ALTER VIEW too.

Add object TRUNCATE hook
Joe Conway: All operations with acl permissions checks should have a corresponding hook so that, for example, mandatory access control (MAC) may be enforced by an extension.

Track statistics for spilling of changes from ReorderBuffer
Amit Kapila: This adds the statistics about transactions spilled to disk from ReorderBuffer.

Bump WAL version
Fujii Masao: Oversight in commit e6d8069522.

Avoid taking a new snapshot for an immutable simple expression in plpgsql
Tom Lane: We already used this optimization if the plpgsql function is read-only.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2019 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).