Features Download
From: David Fetter <david <at> fetter.org>
Subject: == PostgreSQL Weekly News - September 15 2013 ==
Newsgroups: gmane.comp.db.postgresql.announce
Date: Monday 16th September 2013 06:37:57 UTC (over 3 years ago)
== 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
15, 2013.

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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.  Spanish language
to pwn@arpug.com.ar.

== 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

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()
in pg_upgrade.

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
support it.

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
non-error messages.

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
of pages.

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
line type.

Bernd Helmle sent in a patch to create a GUC for page checksums.

Alvaro Herrera sent in another revision of a patch to implement
min-max indexes.

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
bitmap indexes.

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 (pgsql-announce@postgresql.org)
To make changes to your subscription:
CD: 2ms