- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- DragonFlyBSD: nrelease - Fix target for Makefile.usr
- iris: Initial import of resolve code
- iris: add Android build
- iris: comment everything
- iris: Add support for TCS passthrough
- imgui: bump copy
- vulkan: add an overlay layer
- panfrost: Add pandecode (command stream debugger)
- Latest News (cont.)
- Released UPower 0.99.10
- tdf#74664 : Adds FOURIER() formula
- libavcodec: vp8 neon optimizations for aarch64
- Add bytea datatype to ECPG.
- Add DECLARE STATEMENT support to ECPG.
- WINE: Release 4.2.
- Add netbsd support for D compiler and runtime
- sw btlr writing mode: add UI for this
- Use strtof() and not strtod() for float4 input
- sw btlr writing mode: implement ODF filter
- d2d1: Add ID2D1GeometryGroup stub
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Today's Activity
- Add const qualifier
Peter Eisentraut: New code introduced in 050710b36964dee7e1b2bf6b5ef00041fd5d2787.
Other Activity This Week
- Improve planner's understanding of strictness of type coercions
Tom Lane: PG type coercions are generally strict, ie a NULL input must produce a NULL output (or, in domain cases, possibly an error). - Fix DEFAULT-handling in multi-row VALUES lists for updatable views
Dean Rasheed: INSERT ... - Add bytea datatype to ECPG.
Michael Meskes: So far ECPG programs had to treat binary data for bytea column as 'char' type. - Mark pg_config() stable rather than immutable
Joe Conway: pg_config() has been marked immutable since its inception. - Import changes from IMath versions (1.3, 1.29].
Noah Misch: Upstream fixed bugs over the years, but none are confirmed to have affected pgcrypto. - Allow user control of CTE materialization, and change the default behavior
Tom Lane: Historically we've always materialized the full output of a CTE query, treating WITH as an optimization fence (so that, for example, restrictions from the outer query cannot be pushed into it). - Add DECLARE STATEMENT support to ECPG.
Michael Meskes: DECLARE STATEMENT is a statement that lets users declare an identifier pointing at a connection. - Make use of compiler builtins and/or assembly for CLZ, CTZ, POPCNT.
Tom Lane: Test for the compiler builtins __builtin_clz, __builtin_ctz, and __builtin_popcount, and make use of these in preference to handwritten C code if they're available.
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
- 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. - Add DECLARE STATEMENT support to ECPG.
Michael Meskes: DECLARE STATEMENT is a statement that lets users declare an identifier pointing at a connection. - Redesign the partition dependency mechanism
Tom Lane: The original setup for dependencies of partitioned objects had serious problems: 1. - Add bytea datatype to ECPG.
Michael Meskes: So far ECPG programs had to treat binary data for bytea column as 'char' type. - Change function call information to be variable length
Andres Freund: Before this change FunctionCallInfoData, the struct arguments etc for V1 function calls are stored in, always had space for FUNC_MAX_ARGS/100 arguments, storing datums and their nullness in two arrays. - Add combining characters to unaccent.rules
Thomas Munro: Strip certain classes of combining characters, so that accents encoded this way are removed. - Use single-byte Boyer-Moore-Horspool search even with multibyte encodings
Heikki Linnakangas: The old implementation first converted the input strings to arrays of wchars, and performed the conversion on those. - Avoid creation of the free space map for small heap relations
Amit Kapila: Previously, all heaps had FSMs. - Add --min-xid-age and --min-mxid-age options to vacuumdb
Michael Paquier: These two new options can be used to improve the selectivity of relations to vacuum or analyze even further depending on the age of respectively their transaction ID or multixact ID, so as it is possible to prioritize tables to prevent wraparound of one or the other. - Add more columns to pg_stat_ssl
Peter Eisentraut: Add columns client_serial and issuer_dn to pg_stat_ssl.