|| ||David Fetter <david-AT-fetter.org> |
|| ||PostgreSQL Announce <pgsql-announce-AT-postgresql.org> |
|| ||[ANNOUNCE] == PostgreSQL Weekly News - September 15 2013 == |
|| ||Sun, 15 Sep 2013 23:37:57 -0700|
|| ||Article, Thread
== PostgreSQL Weekly News - September 15 2013 ==
The second PostgreSQL CommitFest of the new development cycle has
== PostgreSQL Product News ==
PG Partition Manager 1.4.0, an extension to manage time- or
serial-based table partitioning, released.
Slony-I 2.2.0, a trigger-based replication system for PostgreSQL, released.
== PostgreSQL Jobs for September ==
== PostgreSQL Local ==
Open Source Software for Business" (OSS4B) 2013 will be held in Prato,
Tuscany, Italy on September 19 and 20. Registration is open.
The PostgreSQL Conference China for 2013 will be held October 26-27,
2013 in Hangzhou. Chinese language information here:
The Italian PGDay (PGDay.IT) will be held on October the 25th in
Prato, Tuscany, Italy, at Monash University Center.
To register to the event or get information about the accepted talks
and schedule please see the official web site: http://2013.pgday.it
pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel
in downtown Dublin, Ireland. Registration is open.
PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen. The CfP is open through September
The fourth edition of the Argentinian PostgreSQL Day will be held on
November 14 2013 in Buenos Aires, Argentina. The CfP is open.
PGDay Cuba will be in November, 2013.
== PostgreSQL in the News ==
Planet PostgreSQL: http://planet.postgresql.org/
PostgreSQL Weekly News is brought to you this week by David Fetter
Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to firstname.lastname@example.org, German language
to email@example.com, Italian language to firstname.lastname@example.org. Spanish language
== Applied Patches ==
Robert Haas pushed:
- Introduce InvalidCommandId. This allows a 32-bit field to represent
an *optional* command ID without a separate flag bit. Andres Freund
Peter Eisentraut pushed:
- Show schemas in information_schema.schemata that the current has
access to. Before, it would only show schemas that the current user
owns. Per discussion, the new behavior is more useful and
consistent for PostgreSQL.
- Fix typos
Fujii Masao pushed:
- Remove leftover function prototype. The prototype for
inval_twophase_postcommit wasn't removed when it's definition was
removed in efc16ea520679d713d98a2c7bf1453c4ff7b91ec / the initial
Hot Standby commit. Andres Freund
Bruce Momjian pushed:
- psql: honor 'footer' option for expanded output. "No rows"
previously only honored the tuples-only option. Per report from Eli
- psql: fix \copy stdin trailing space requirement. Previously a
trailing space was required for \copy ... stdin: copy foo from stdin
; Etsuro Fujita
- Add comment for VARSIZE_ANY_EXHDR macro. Gurjeet Singh
- docs: Update libpq and testlo examples. Josh Kupershmidt
- fuzzystrmatch: replace broken link in C comment. Laurenz Albe.
Kevin Grittner pushed:
- Create index on srt table in citext regression tests. Comments and
the tests make clear that the intent is to test with and without an
index, but there was no index.
Noah Misch pushed:
- Ignore interrupts during quickdie(). Once the administrator has
called for an immediate shutdown or a backend crash has triggered a
reinitialization, no mere SIGINT or SIGTERM should change that
course. Such derailment remains possible when the signal arrives
before quickdie() blocks signals. That being a narrow race
affecting most PostgreSQL signal handlers in some way, leave it for
another patch. Back-patch this to all supported versions.
== Rejected Patches (for now) ==
No one was disappointed this week :-)
== Pending Patches ==
Peter Geoghegan sent in two revisions of a patch to implement INSERT
... ON DUPLICATE KEY LOCK FOR UPDATE.
Zoltan Boszormenyi sent in another revision of a patch to implement
fetch readahead for ECPG.
Blake Smith sent in another revision of a patch to speed up queries
with hstore using GIN indexes.
Heikki Linnakangas and Stephen Frost traded patches to fix an issue in
libpq's interaction with SSL.
Satoshi Nagayasu sent in two more revisions of a patch to collect a
statistic for WAL buffer dirty writes called
Noah Misch sent in a patch to fix a case where SIGQUIT sent after a
query cancel, the cancel takes precedent and the backend survives.
Bruce Momjian sent in a patch to issue a warning when SET TRANSACTION
is called outside a transaction block.
Ronan Dunklau sent in a patch to implement triggers on foreign tables.
Bruce Momjian sent in a patch to fix some functions in
contrib/unaccent to be immutable.
Fujii Masao sent in another revision of a patch to compress full-page
Peter Eisentraut sent in a patch to document how to use FOP to build
the PDF documentation.
Samrat Revagade and Sawada Masahiko traded patches to allow fail-back
without taking a fresh backup.
Robert Haas sent in a set of patches to allow terminating background
workers, a way to flag same, and some test code. This may eventually
lead to parallel query.
Peter Eisentraut sent in a patch to remove the maintainer-check
target, roll its functionality into the regular build, and include
Andrew Dunstan's check for duplicate OIDs.
Peter Eisentraut sent in a patch to split off pg_fatal() from pg_log()
Kevin Grittner sent in a patch to implement a record_identical()
operator as part of the infrastructure for maintaining materialized
MauMau sent in another revision of a patch to make sure shutting down
in immediate mode is reliable.
Andrew (RhodiumToad) Gierth sent in another revision of a patch to
make UNNEST take multiple heterogeneous array arguments and have
TABLE() do similar with multiple SRFs.
Robert Haas and Amit Kapila sent in another revision of a patch to
implment dynamic shared memory.
Dimitri Fontaine sent in a patch to complete the stock PL support for
Peter Eisentraut sent in another revision of a patch to implement
Peter Eisentraut sent in a patch to use asprintf() on platforms that
Atri Sharma and Andrew (RhodiumToad) Gierth traded patches
implementing WITHIN GROUP.
Marko (johto) Tiikkaja sent in a patch to implement a strict mode for
Richard Poole sent in a WIP patch to adds the MAP_HUGETLB flag to
mmap() for shared memory on systems that support it. The patch is
based on Christian Kruse's patch from last year, incorporating
suggestions from Andres Freund.
Marko (johto) Tiikkaja sent in three more revisions of a patch to add
a COMPACT mode for errors where the CONTEXT field is omitted for all
Marko (johto) Tiikkaja sent in two revisions of a patch to
(optionally) print more information on STRICT failures in PL/PgSQL:
Amit Kapila sent in another revision of a patch to compute the max LSN
Peter Eisentraut sent in another revision of a patch to implement
Andres Freund sent in a patch to allow custom GUCs to be nested more
that one level in config files.
Peter Eisentraut sent in another revision of a patch to revive the
Bernd Helmle sent in a patch to create a GUC for page checksums.
Alvaro Herrera sent in another revision of a patch to implement
Andres Freund sent in a flock of patches intended to help with logical
changesets. Details here:
Marko (johto) Tiikkaja sent in two revisions of a patch to add
ASSERTions to PL/pgsql.
Abhijit Menon-Sen sent in another revision of a patch to implement
Amit Kapila sent in two more revisions of a patch to fix some
inconsistent behavior in table inheritance.
Satoshi Nagayasu sent in another revision of a patch to update
Alexander Korotkov sent in another revision of a patch to improve GIN
indexes with optional information.
Satoshi Nagayasu sent in another revision of a patch to add CLUSTER
Sent via pgsql-announce mailing list (email@example.com)
To make changes to your subscription:
to post comments)