Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Recent Activity

Disallow changing an inherited column's type if not all parents changed
Tom Lane: If a table inherits from multiple unrelated parents, we must disallow changing the type of a column inherited from multiple such parents, else it would be out of step with the other parents.

Apply constraint exclusion more generally in partitioning
Alvaro Herrera: We were applying constraint exclusion on the partition constraint when generating pruning steps for a clause, but only for the rather restricted situation of them being boolean OR operators; however it is possible to have differently shaped clauses that also benefit from constraint exclusion.

Add safeguards in LSN, numeric and float calculation for custom errors
Michael Paquier: Those data types use parsing and/or calculation wrapper routines which can generate some generic error messages in the event of a failure.

Add sort support routine for the inet data type
Peter Geoghegan: Add sort support for inet, including support for abbreviated keys.

Add support for --jobs in reindexdb
Michael Paquier: When doing a schema-level or a database-level operation, a list of relations to build is created which gets processed in parallel using multiple connections, based on the recent refactoring for parallel slots in src/bin/scripts/.

Tweak our special-case logic for the IANA "Factory" timezone
Tom Lane: pg_timezone_names() tries to avoid showing the "Factory" zone in the view, mainly because that has traditionally had a very long "abbreviation" such as "Local time zone must be set--see zic manual page", so that showing it messes up psql's formatting of the whole view.

doc: Add support for xref to command and function elements
Peter Eisentraut: Discussion:

Add CREATE DATABASE LOCALE option
Peter Eisentraut: This sets both LC_COLLATE and LC_CTYPE with one option.

Install dependencies to prevent dropping partition key columns
Tom Lane: The logic in ATExecDropColumn that rejects dropping partition key columns is quite an inadequate defense, because it doesn't execute in cases where a column needs to be dropped due to cascade from something that only the column, not the whole partitioned table, depends on.

Make better use of the new List implementation in a couple of places
David Rowley: In nodeAppend.c and nodeMergeAppend.c there were some foreach loops which looped over the list of subplans and only performed any work if the subplan index was found in a Bitmapset.

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 This Year

Disable support for partitionwise joins in problematic cases
Etsuro Fujita: Commit f49842d, which added support for partitionwise joins, built the child's tlist by applying adjust_appendrel_attrs() to the parent's.

Doc: still further copy-editing for v11 release notes
Tom Lane: Justin Pryzby and myself.

Doc: further copy-editing for v11 release notes
Tom Lane: Justin Pryzby, Jonathan S.

Add support for nearest-neighbor (KNN) searches to SP-GiST
Alexander Korotkov: Currently, KNN searches were supported only by GiST.

Fully enforce uniqueness of constraint names
Tom Lane: It's been true for a long time that we expect names of table and domain constraints to be unique among the constraints of that table or domain.

doc: JIT is enabled by default in PG 12
Bruce Momjian: JIT was disabled by default in a PG 11 in a separate commit that will normally not appear in the PG 12 git logs.

Add CSV table output mode in psql
Tom Lane: "\pset format csv", or --csv, selects comma-separated values table format.

Add DECLARE STATEMENT support to ECPG.
Michael Meskes: DECLARE STATEMENT is a statement that lets users declare an identifier pointing at a connection.

Use strtof() and not strtod() for float4 input
Andrew Gierth: Using strtod() creates a double-rounding problem; the input decimal value is first rounded to the nearest double; rounding that to the nearest float may then give an incorrect result. An example is that 7.038531e-26 when input via strtod and then rounded to float4 gives 0xAE43FEp-107 instead of the correct 0xAE43FDp-107. Values output by earlier PG versions with extra_float_digits=3 should all be read in with the same values as previously.

Error position support for partition specifications
Peter Eisentraut: Add support for error position reporting for partition specifications.

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).