Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

First-draft release notes for 9.4.1 et al
Tom Lane: As usual, the release notes for older branches will be made by cutting these down, but put them up for community review first. Note: a significant fraction of these items don't apply to 9.4.1, only to older branches, because the fixes already appeared in 9.4.0.

Other Activity This Week

Add usebypassrls to pg_user and pg_shadow
Stephen Frost: The row level security patches didn't add the 'usebypassrls' columns to the pg_user and pg_shadow views on the belief that they were deprecated, but we havn't actually said they are and therefore we should include it.

Fix column-privilege leak in error-message paths
Stephen Frost: While building error messages to return to the user, BuildIndexValueDescription, ExecBuildSlotValueDescription and ri_ReportViolation would happily include the entire key or entire row in the result returned to the user, even if the user didn't have access to view all of the columns being included. Instead, include only those columns which the user is providing or which the user has select rights on.

Recent Activity

First-draft release notes for 9.4.1 et al
Tom Lane: As usual, the release notes for older branches will be made by cutting these down, but put them up for community review first. Note: a significant fraction of these items don't apply to 9.4.1, only to older branches, because the fixes already appeared in 9.4.0.

Add usebypassrls to pg_user and pg_shadow
Stephen Frost: The row level security patches didn't add the 'usebypassrls' columns to the pg_user and pg_shadow views on the belief that they were deprecated, but we havn't actually said they are and therefore we should include it.

Fix column-privilege leak in error-message paths
Stephen Frost: While building error messages to return to the user, BuildIndexValueDescription, ExecBuildSlotValueDescription and ri_ReportViolation would happily include the entire key or entire row in the result returned to the user, even if the user didn't have access to view all of the columns being included. Instead, include only those columns which the user is providing or which the user has select rights on.

Replace a bunch more uses of strncpy() with safer coding
Tom Lane: strncpy() has a well-deserved reputation for being unsafe, so make an effort to get rid of nearly all occurrences in HEAD. A large fraction of the remaining uses were passing length less than or equal to the known strlen() of the source, in which case no null-padding can occur and the behavior is equivalent to memcpy(), though doubtless slower and certainly harder to reason about.

vacuumdb: enable parallel mode
Alvaro Herrera: This mode allows vacuumdb to open several server connections to vacuum or analyze several tables simultaneously. Author: Dilip Kumar.

Tweak BRIN minmax operator class
Alvaro Herrera: In the union support proc, we were not checking the hasnulls flag of value A early enough, so it could be skipped if the "allnulls" flag in value B is set.

More fixes for abbreviated keys infrastructure
Robert Haas: First, when LC_COLLATE = C, bttext_abbrev_convert should use memcpy() rather than strxfrm() to construct the abbreviated key, because the authoritative comparator uses memcpy().

Use abbreviated keys for faster sorting of text datums
Robert Haas: This commit extends the SortSupport infrastructure to allow operator classes the option to provide abbreviated representations of Datums; in the case of text, we abbreviate by taking the first few characters of the strxfrm() blob.

Another attempt at fixing Windows Norwegian locale
Heikki Linnakangas: Previous fix mapped "Norwegian (Bokmål)" locale, which contains a non-ASCII character, to the pure ASCII alias "norwegian-bokmal".

Improve performance of EXPLAIN with large range tables
Tom Lane: As of 9.3, ruleutils.c goes to some lengths to ensure that table and column aliases used in its output are unique.

Most Popular In The Past Month

vacuumdb: enable parallel mode
Alvaro Herrera: This mode allows vacuumdb to open several server connections to vacuum or analyze several tables simultaneously. Author: Dilip Kumar.

Add a default local latch for use in signal handlers
Andres Freund: To do so, move InitializeLatchSupport() into the new common process initialization functions, and add a new global variable MyLatch. MyLatch is usable as soon InitPostmasterChild() has been called (i.e.

Another attempt at fixing Windows Norwegian locale
Heikki Linnakangas: Previous fix mapped "Norwegian (Bokmål)" locale, which contains a non-ASCII character, to the pure ASCII alias "norwegian-bokmal".

Add barriers to the latch code
Andres Freund: Since their introduction latches have required barriers in SetLatch and ResetLatch - but when they were introduced there wasn't any barrier abstraction.

Use correct text domain for errcontext() appearing within ereport().
Tom Lane: The mechanism added in commit dbdf9679d7d61b03a3bf73af9b095831b7010eb5 for associating the correct translation domain with errcontext strings potentially fails in cases where errcontext() is used within an ereport() macro.

Use abbreviated keys for faster sorting of text datums
Robert Haas: This commit extends the SortSupport infrastructure to allow operator classes the option to provide abbreviated representations of Datums; in the case of text, we abbreviate by taking the first few characters of the strxfrm() blob.

Improve performance of EXPLAIN with large range tables
Tom Lane: As of 9.3, ruleutils.c goes to some lengths to ensure that table and column aliases used in its output are unique.

Allow latches to wait for socket writability without waiting for readability
Andres Freund: So far WaitLatchOrSocket() required to pass in WL_SOCKET_READABLE as that solely was used to indicate error conditions, like EOF.

Tweak BRIN minmax operator class
Alvaro Herrera: In the union support proc, we were not checking the hasnulls flag of value A early enough, so it could be skipped if the "allnulls" flag in value B is set.

More fixes for abbreviated keys infrastructure
Robert Haas: First, when LC_COLLATE = C, bttext_abbrev_convert should use memcpy() rather than strxfrm() to construct the abbreviated key, because the authoritative comparator uses memcpy().

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