PostgeSQL is a leading open-source SQL database server.
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.