Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

In postgres_fdw, allow CASE expressions to be pushed to the remote server
Tom Lane: This is simple enough except for the need to check whether CaseTestExpr nodes have a collation that is not derived from a remote Var.

Add PostgresVersion.pm method to emit the major version string
Andrew Dunstan: For versions before 10, this will produce dotted notation unless a separator argument is given, in which case it is used.

Add adjust_conf method to PostgresNode
Andrew Dunstan: This method will modify or delete an existing line in the config file rather than simply appending to the file.

Add support for SET ACCESS METHOD in ALTER TABLE
Michael Paquier: The logic used to support a change of access method for a table is similar to changes for tablespace or relation persistence, requiring a table rewrite with an exclusive lock of the relation changed.

Recent Activity

In postgres_fdw, allow CASE expressions to be pushed to the remote server
Tom Lane: This is simple enough except for the need to check whether CaseTestExpr nodes have a collation that is not derived from a remote Var.

Add PostgresVersion.pm method to emit the major version string
Andrew Dunstan: For versions before 10, this will produce dotted notation unless a separator argument is given, in which case it is used.

Add adjust_conf method to PostgresNode
Andrew Dunstan: This method will modify or delete an existing line in the config file rather than simply appending to the file.

Add support for SET ACCESS METHOD in ALTER TABLE
Michael Paquier: The logic used to support a change of access method for a table is similar to changes for tablespace or relation persistence, requiring a table rewrite with an exclusive lock of the relation changed.

pg_resetxlog: add option to set oldest xid & use by pg_upgrade
Bruce Momjian: Add pg_resetxlog -u option to set the oldest xid in pg_control.

Allow numeric scale to be negative or greater than precision
Dean Rasheed: Formerly, when specifying NUMERIC(precision, scale), the scale had to be in the range [0, precision], which was per SQL spec.

Fix incorrect comment for get_agg_clause_costs
David Rowley: Adjust the header comment in get_agg_clause_costs so that it matches what the function currently does.

Get rid of artificial restriction on hash table sizes on Windows
Tom Lane: The point of introducing the hash_mem_multiplier GUC was to let users reproduce the old behavior of hash aggregation, i.e.

Remove configure-time thread safety checking (thread_test.c).
Tom Lane: This testing was useful when it was written, nigh twenty years ago, but it seems fairly pointless for any platform built in the last dozen or more years.

Unify parsing logic for command-line integer options
Michael Paquier: Most of the integer options for command-line binaries now make use of a single routine able to do the job, fixing issues with the detection of sloppy values caused for example by the use of atoi(), that fails on strings beginning with numerical characters with junk trailing characters. This commit cuts down the number of strings requiring translation by 26 per my count, switching the code to have two error types for invalid and out-of-range values instead. Much more could be done here, with float or even int64 options, but int32 was the most appealing case as it is possible to rely on strtol() to do the job reliably.

PostgreSQL Release Tags

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

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

Remove dead assignment to local variable
Heikki Linnakangas: This should have been removed in commit 7e30c186da, which split the loop into two.

Un-break AIX build, take 2.
Tom Lane: I incorrectly diagnosed the reason why hoverfly is unhappy.

Add support for SET ACCESS METHOD in ALTER TABLE
Michael Paquier: The logic used to support a change of access method for a table is similar to changes for tablespace or relation persistence, requiring a table rewrite with an exclusive lock of the relation changed.

Reduce the number of pallocs when building partition bounds
David Rowley: In each of the create_*_bound() functions for LIST, RANGE and HASH partitioning, there were a large number of palloc calls which could be reduced down to a much smaller number. In each of these functions, an array was built so that we could qsort it before making the PartitionBoundInfo.

Doc: add info about timestamps with fractional-minute UTC offsets
Tom Lane: Our code has supported fractional-minute UTC offsets for ages, but there was no mention of the possibility in the main docs, and only a very indirect reference in Appendix B.

vacuumdb: Correct comment about --force-index-cleanup
Peter Geoghegan: Commit 3499df0d added a comment that incorrectly suggested that--force-index-cleanup did not appear in the same major version as the similar --no-index-cleanup option.

Fix small inconsistencies in catalog definition of multirange operators
Alexander Korotkov: This commit fixes the description of a couple of multirange operators and oprjoin for another multirange operator.

Prevent numeric overflows in parallel numeric aggregates
Dean Rasheed: Formerly various numeric aggregate functions supported parallel aggregation by having each worker convert partial aggregate values to Numeric and use numeric_send() as part of serializing their state.

Allow CustomScan providers to say whether they support projections
Tom Lane: Previously, all CustomScan providers had to support projections, but there may be cases where this is inconvenient.

Un-break AIX build
Tom Lane: In commit d0a02bdb8, I'd supposed that uniformly probing for ldap_bind would make the intent clearer.

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