== PostgreSQL Weekly News - October 20 2013 == - Mailing list pgsql-announce
| From | David Fetter |
|---|---|
| Subject | == PostgreSQL Weekly News - October 20 2013 == |
| Date | |
| Msg-id | 20131021052058.GC1201@fetter.org Whole thread Raw |
| List | pgsql-announce |
== PostgreSQL Weekly News - October 20 2013 == PgDay Argentina 2013 needs money. Please give. http://www.postgresql.org.ar/pgday2013/crowdfunding?lang=en Commitfest II for the 9.4 cycle has ended with excellent progress through the patch queued. Twenty patches were pushed, some quite significant in scope. == PostgreSQL Product News == Pyrseas 0.7.0b1, a toolkit for PostgreSQL version control, released. https://github.com/jmafc/Pyrseas == PostgreSQL Jobs for October == http://archives.postgresql.org/pgsql-jobs/2013-10/threads.php == PostgreSQL Local == 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 The PostgreSQL Conference China for 2013 will be held October 26-27, 2013 in Hangzhou. Chinese language information here: https://wiki.postgresql.org/wiki/Pgconf_cn2013 Registration: http://bbs.pgsqldb.com/client/bm.php pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel in downtown Dublin, Ireland. Registration is open. http://2013.pgconf.eu/ PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland Industrial Museum in Oberhausen. The CfP is open through September 15, 2013. http://2013.pgconf.de/ The fourth edition of the Argentinian PostgreSQL Day will be held on November 14 2013 in Buenos Aires, Argentina. http://wiki.postgresql.org/wiki/PGDay_Argentina_2013 PGDay Cuba will be in November, 2013. http://postgresql.uci.cu/ == 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: - Fix details missed by dynamic shared memory patch. Additional documentation update, and a comment fix. Both issues reported by Amit Kapila. http://git.postgresql.org/pg/commitdiff/05a0283e7a48ffdca96cb6dd94fa5bae06e29bd1 - In dsm_impl_windows, don't error out when the segment already exists. This is the behavior of the other implementations, and the behavior expected by the callers of this function. Amit Kapila http://git.postgresql.org/pg/commitdiff/e5158613676d940cf71ecfb5c73ac933746ac847 - initdb: Suppress dynamic shared memory when probing for max_connections. This might not be the right long-term solution here, but it will hopefully turn the buildfarm green again. Oversight noted by Andres Freund http://git.postgresql.org/pg/commitdiff/d41ab71712a4457ed39d5471b23949872ac91def - Remove spinlock support for SINIX, Sun3, and NS32K. All of these platforms are very much obsolete. As far as I can determine, the last version of SINIX, later renamed Reliant, occurred some time between 2002 and 2005. The last release of SunOS that would run on a sun3 was released in November of 1991; the last release of OpenBSD which supported that platform was in 2001. The highest clock speed of any processor in the family was 25MHz. The NS32K (national semiconductor 320xx) architecture was retired in 1990. Support can be re-added if a maintainer emerges for any of these platforms, but it seems unlikely. Reviewed by Andres Freund. http://git.postgresql.org/pg/commitdiff/81051a86bcecdc681592725139fe610b2c1d1428 - Remove IRIX port. Development of IRIX has been discontinued, and support is scheduled to end in December of 2013. Therefore, there will be no supported versions of this operating system by the time PostgreSQL 9.4 is released. Furthermore, we have no maintainer for this platform. http://git.postgresql.org/pg/commitdiff/ea91a6be89575095f61ebf36d67c2df98be093db - Provide a reliable mechanism for terminating a background worker. Although previously-introduced APIs allow the process that registers a background worker to obtain the worker's PID, there's no way to prevent a worker that is not currently running from being restarted. This patch introduces a new API TerminateBackgroundWorker() that prevents the background worker from being restarted, terminates it if it is currently running, and causes it to be unregistered if or when it is not running. Patch by me. Review by Michael Paquier and KaiGai Kohei. http://git.postgresql.org/pg/commitdiff/523beaa11bdf6a9864e8978b467ed586b792c9ca - Allow only some columns of a view to be auto-updateable. Previously, unless all columns were auto-updateable, we wouldn't inserts, updates, or deletes, or at least not without a rule or trigger; now, we'll allow inserts and updates that target only the auto-updateable columns, and deletes even if there are no auto-updateable columns at all provided the view definition is otherwise suitable. Dean Rasheed, reviewed by Marko Tiikkaja http://git.postgresql.org/pg/commitdiff/cab5dc5daf2f6f5da0ce79deb399633b4bb443b5 Bruce Momjian pushed: - docs: correct 9.1 and 9.2 release note mention of timeline switch fix. Backpatch through 9.1. KONDO Mitsumasa http://git.postgresql.org/pg/commitdiff/f918c52f65aa28fb8c00d3f7078ff7b4788929dc - Allow 5+ digit years for non-ISO timestamp/date strings, where appropriate. Report from Haribabu Kommi http://git.postgresql.org/pg/commitdiff/7778ddc7a2d5b006edbfa69cdb44b8d8c24ec1ff Peter Eisentraut pushed: - doc: Enable book index in XSLT builds. The XSLT toolchain requires an empty <index> element where the index is supposed to appear. Add that with conditionals to hide it from the DSSSL build. http://git.postgresql.org/pg/commitdiff/90c7b7d16bb3a90fc9168ff8942fbf78308e727d - Switch order of -lpgport and -lpgcommon. Conceptually, libpgcommon can depend on libpgport, but not the other way around. In the past, this might not have mattered, but it's needed now for asprintf. http://git.postgresql.org/pg/commitdiff/63f32f3416a8b4f8e057dc184e8e8eae734ccc8a - doc: Configure TOC generation in XSLT HTML build. The default table of contents in the XSLT HTML build is much too big and deep. Configure it to look more like the one that is currently being produced by the DSSSL build. http://git.postgresql.org/pg/commitdiff/ed632ab21e9c638328498a85ccf77452645943bb - Fix for lack of va_copy() on certain Windows versions. Based-on-patch-by: David Rowley <dgrowleyml@gmail.com> http://git.postgresql.org/pg/commitdiff/c2316dcda1cd057d7d4a56e3a51e3f8f0527e906 - Add libpgport to isolationtester on MSVC. From: Asif Naeem <anaeem.it@gmail.com> http://git.postgresql.org/pg/commitdiff/595a6a035008cfa76faa2f284e91704f18673d13 - Switch order of libpgport and libpgcommon in MSVC build as well http://git.postgresql.org/pg/commitdiff/3c093b4ad267bbba1bc1e403719dddb881d2696e - Move pgfnames() from libpgport to libpgcommon. It requires pstrdup() from libpgcommon. http://git.postgresql.org/pg/commitdiff/ba7c5975adea74c6f17bdb0e0427ad85962092a2 - Move rmtree() from libpgport to libpgcommon. It requires pgfnames() from libpgcommon. http://git.postgresql.org/pg/commitdiff/2e6bc4b806ca92433932b34c019293a201f03e11 - Add *.pot to .gitignore http://git.postgresql.org/pg/commitdiff/07bf70356c4a22939dfd89f3fb48d1a50c901e13 - Add libpgcommon to backend gettext source files. This ought to have been done when libpgcommon was split off from libpgport. http://git.postgresql.org/pg/commitdiff/713a9f210d5cf5d94cc420b01eef5183569402e0 Alvaro Herrera pushed: - Silence compiler warning when SSL not in use. Per Jaime Casanova and Vik Fearing http://git.postgresql.org/pg/commitdiff/86029b31e5c71be5f9aceba0da2c609496435418 Andrew Dunstan pushed: - Return valid json when converting an empty hstore. Oskari Saarenmaa. http://git.postgresql.org/pg/commitdiff/bbe4deac1b98594206a024c9e91d664b3c3410d9 Noah Misch pushed: - Consistently use unsigned arithmetic for alignment calculations. This avoids an assumption about the signed number representation. It is anticipated to have no functional changes on supported configurations; many two's complement assumptions remain elsewhere. Per a suggestion from Andres Freund. http://git.postgresql.org/pg/commitdiff/709170b790c11b4012004a6baf11a0fc6ec950de == Rejected Patches (for now) == No one was disappointed this week :-) == Pending Patches == David Fetter sent in another revision of a patch to allow CREATE FOREIGN TABLE (... LIKE ...). Andres Freund sent another flock of patches for logical changeset generation. Vik Fearing sent in another revision of a patch to document how and when subqueries can modify data. Vik Fearing sent in another revision of a patch to allow stats collection for the CLUSTER command. Robert Haas sent in a patch to remove support for the Alpha architecture. Tomas Vondra sent in two versions of a patch to add flow charts for the FDW API. Vik Fearing sent in two more revisions of a patch to add pg_sleep_for(interval) and pg_sleep_until(timestamptz). KONDO Mitsumasa sent in two approaches to a patch to improve pg_stat_statements. Rajeev Rastogi sent in a patch to ensure that COPY FROM STDIN shows a count tag, which it did not before. Fabrízio de Royes Mello sent in another revision of a patch to enable time-delayed standbys. Dean Rasheed sent in another revision of a patch to allow tab completion for views and foreign tables in psql. Peter Geoghegan sent in a patch to create an autovacuum_work_mem GUC. Nigel Heron sent in a WIP patch to keep track of the number of bytes sent and received by the server over its communication sockets.
pgsql-announce by date: