Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

meson: Add prefix=/usr/local/pgsql to default_options
Andres Freund: autoconf set PREFIX to /usr/local/pgsql, so using the same default for meson makes sense.

Introduce SYSTEM_USER
Michael Paquier: SYSTEM_USER is a reserved keyword of the SQL specification that, roughly described, is aimed at reporting some information about the system user who has connected to the database server.

Increase width of RelFileNumbers from 32 bits to 56 bits
Robert Haas: RelFileNumbers are now assigned using a separate counter, instead of being assigned from the OID counter.

ci: Add hint about downloadable logs to README
Andres Freund: I (Andres) chose to backpatch this to 15, as it seems better to keep the README the same.

Recent Activity

meson: Add prefix=/usr/local/pgsql to default_options
Andres Freund: autoconf set PREFIX to /usr/local/pgsql, so using the same default for meson makes sense.

Introduce SYSTEM_USER
Michael Paquier: SYSTEM_USER is a reserved keyword of the SQL specification that, roughly described, is aimed at reporting some information about the system user who has connected to the database server.

Increase width of RelFileNumbers from 32 bits to 56 bits
Robert Haas: RelFileNumbers are now assigned using a separate counter, instead of being assigned from the OID counter.

ci: Add hint about downloadable logs to README
Andres Freund: I (Andres) chose to backpatch this to 15, as it seems better to keep the README the same.

pgstat: Fix transactional stats dropping for indexes
Andres Freund: Because index creation does not go through heap_create_with_catalog() we didn't call pgstat_create_relation(), leading to index stats of a newly created realtion not getting dropped during rollback.

Remove PQsendQuery support in pipeline mode
Alvaro Herrera: The extended query protocol implementation I added in commit acb7e4eb6b1c has bugs when used in pipeline mode.

Used optimized linear search in more code paths
Michael Paquier: This commit updates two code paths to use pg_lfind32() introduced by b6ef167 with TransactionId arrays:- At the end of TransactionIdIsInProgress(), when checking for the case of still running but overflowed subxids.

Make ALTER DEFAULT PRIVILEGES require privileges, not membership
Robert Haas: If role A is a direct or indirect member of role B but does not inherit B's privileges (because at least one relevant grant was created WITH INHERIT FALSE) then A should not be permitted to bypass privilege checks that require the privileges of B.

walmethods.c/h: Make WalWriteMethod more object-oriented
Robert Haas: Normally when we use object-oriented programming techniques, we provide a pointer to an object and then some way of looking up the associated table of callbacks, but walmethods.c/h took the alternative approach of providing only a pointer to the table of callbacks and thus imposed the artificial restriction that there could only ever be one object of each type, so that the callbacks could find it via a global variable.

walmethods.c/h: Make Walfile a struct, rather than a void *
Robert Haas: This makes the curent file position and pathname visible in a generic way, so we no longer need current_walfile_name global variable or the get_current_pos() method.

PostgreSQL Release Tags

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

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

Bump minimum Perl version to 5.14
John Naylor: The oldest vendor-shipped Perl in the buildfarm is 5.14.2, which is the last version that Debian Wheezy shipped.

Fix incorrect uses of Datum conversion macros
Peter Eisentraut: Since these macros just cast whatever you give them to the designated output type, and many normal uses also cast the output type further, a number of incorrect uses go undiscovered.

Fix new pg_publication_tables query
Tom Lane: The addition of published column names forgot to filter on attisdropped, leading to cases where you could see "........pg.dropped.1........" or the like as a reportedly-published column. While we're here, rewrite the new subquery to get a more efficient plan for it. Hou Zhijie, per report from Jaime Casanova.

Build all Flex files standalone
John Naylor: The proposed Meson build system will need a way to ignore certain generated files in order to coexist with the autoconf build system, and C files generated by Flex which are #include'd into .y files make this more difficult.

Make more effort to put a sentinel at the end of allocated memory
David Rowley: Traditionally, in MEMORY_CONTEXT_CHECKING builds, we only ever marked a sentinel byte just beyond the requested size if there happened to be enough space on the chunk to do so.

Make ALTER DEFAULT PRIVILEGES require privileges, not membership
Robert Haas: If role A is a direct or indirect member of role B but does not inherit B's privileges (because at least one relevant grant was created WITH INHERIT FALSE) then A should not be permitted to bypass privilege checks that require the privileges of B.

Used optimized linear search in more code paths
Michael Paquier: This commit updates two code paths to use pg_lfind32() introduced by b6ef167 with TransactionId arrays:- At the end of TransactionIdIsInProgress(), when checking for the case of still running but overflowed subxids.

Bump minimum version of Bison to 2.3
John Naylor: Since the retirement of some older buildfarm members, the oldest Bison that gets regular testing is 2.3.

Bump minimum version of Flex to 2.5.35
John Naylor: Since the retirement of some older buildfarm members, the oldest Flex that gets regular testing is 2.5.35.

Doc: Explain about Column List feature
Amit Kapila: Add a new logical replication section for "Column Lists" (analogous to the Row Filters page).

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