== PostgreSQL Weekly News - June 23 2013 ==
PGDay Italy will be in Prato, Tuscany on October 25, 2013.
Watch this space for more details.
== PostgreSQL Product News ==
pgBadger 3.4, a parallel PostgreSQL log analyzer written in Perl,
PG Commander, a PostgreSQL client for OS X, released.
PostGIS 2.1.0beta3, the industry standard geographic information
system for PostgreSQL, released.
psycopg2 2.5.1, a Python connector for PostgreSQL, released.
== PostgreSQL Jobs for June ==
== PostgreSQL Local ==
We're going to have a booth at OSCON this year. Please sign up and
hang out at the booth for an hour or two:
PGDay UK 2013 is July 12, 2013. Registration is open.
PostgreSQL Brazil will be held August 15-17, 2013 in Porto Velho, RO,
Postgres Open 2013 will be in Chicago, IL, USA, September 16-18.
Early Bird registration and call for presentations closes June 30th.
pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel
in downtown Dublin, Ireland. The CfP is open.
PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen. The CfP is open through September
== 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 [email protected], German language
to [email protected], Italian language to [email protected] Spanish language
to [email protected]
== Applied Patches ==
Jeff Davis pushed:
- Add buffer_std flag to MarkBufferDirtyHint(). MarkBufferDirtyHint()
writes WAL, and should know if it's got a standard buffer or not.
Currently, the only callers where buffer_std is false are related to
the FSM. In passing, rename XLOG_HINT to XLOG_FPI, which is more
descriptive. Back-patch to 9.3.
Peter Eisentraut pushed:
- psql: Re-allow -1 together with -c or -l
- initdb: Add blank line before output about checksums. This
maintains the logical grouping of the output better.
- Further update CREATE FUNCTION documentation about argument names.
More languages than SQL and PL/pgSQL actually support parameter
- Clarify terminology standalone backend vs. single-user mode. Most
of the documentation uses "single-user mode", so use that in the
code as well. Adjust the documentation to match the new error
message wording. Also add a documentation index entry for
"single-user mode". Based-on-patch-by: Jeff Janes.
- doc: Fix date in EPUB manifest. If there is no element, the
publication date for the EPUB manifest is taken from the copyright
year. But something like "1996-2013" is not a legal date
specification. So the EPUB output currently fails epubcheck. Put
in a separate element with the current year. Put it in
legal.sgml, because copyright.pl already instructs to update that
manually, so it hopefully won't be missed.
Simon Riggs pushed:
- Fix docs on lock level for ALTER TABLE VALIDATE. ALTER TABLE ..
VALIDATE CONSTRAINT previously gave incorrect details about lock
levels and therefore incomplete reasons to use the option. Initial
bug report and fix from Marko Tiikkaja Reworded by me to include
comments by Kevin Grittner
- Ensure no xid gaps during Hot Standby startup. In some cases with
higher numbers of subtransactions it was possible for us to
incorrectly initialize subtrans leading to complaints of missing
pages. Bug report by Sergey Konoplev. Analysis and fix by Andres
Kevin Grittner pushed:
- Fix the create_index regression test for Danish collation. In
Danish collations, there are letter combinations which sort higher
than 'Z'. A test for values > 'WA' was picking up rows where the
value started with 'Ants Aasma', causing the test to fail.
Backpatch to 9.2, where the failing test was added. Per report from
Svenne Krap and analysis by Jeff Janes
Bruce Momjian pushed:
- Modernize entab source code. Remove halt.c, improve comments,
rename manual page file.
Fujii Masao pushed:
- Support TB (terabyte) memory unit in GUC variables. Patch by Simon
Riggs, reviewed by Jeff Janes and me.
Tom Lane pushed:
- Add a comment warning against use of pg_usleep() for long sleeps.
Follow-up to commit 873ab97219caabeb2f7b390268a4fe01e2b7518c, in
which I noted that WaitLatch was a better solution in the commit log
message, but neglected to add any documentation in the code.
== Rejected Patches (for now) ==
No one was disappointed this week :-)
== Pending Patches ==
David Fetter sent in another revision of a patch to implement
Andres Freund sent in a patch to clarify an error message on Linux.
Robins Tharakan sent in another revision of a patch to add regression
tests for SET xxx.
Alexander Korotkov sent in two more revisions of a patch to add more
information to GIN indexes.
Alexander Korotkov sent in two more revisions of a patch to add
ordering in GIN indexes.
Alexander Korotkov sent in two more revisions of a patch to add fast
scan to GIN indexes.
Ian Link sent in a patch to improve the fast GIN cache.
Michael Paquier sent in five more revisions of a patch to implement
Jeff Davis sent in another revision of a patch to have pg_filedump
take checksums, among other things, into account.
Amit Langote sent in a patch to correct a comment in heaptuple.c.
Cedric Villemain sent in a patch to fix a bug and add new features to
Etsuro Fujita sent in four more revisions of a patch to remove unused
Nicholas White and Troels Nielsen traded patches to allow the SQL
standard IGNORE/RESPECT NULLS in lead and lag window functions.
Heikki Linnakangas sent in two more revisions of a patch to scale
Amit Kapila sent in another revision of a patch to allow changing GUCs
persistently from SQL.
Fabien COELHO sent in another revision of a patch to add long options
Andres Freund sent in a patch to create a new contrib module: xidfuncs.
Jeff Janes sent in another revision of a patch to add a startup option
Josh Kupershmidt sent in a patch to rename the specs directory to
something that won't interfer with certain OSs.
Andres Freund sent in another revision of a patch to create
infrastructure for and implement examples of pluggable compressors.
Gurjeet Singh sent in a patch to implement a function
pg_test_reload_conf() which allows you to know whether the changes
you've made to configuration parameters have actually taken effect
after a SIGHUP.
KONDO Mitsumasa sent in another revision of a patch to add --progress
Andres Freund sent in two more revisions of the set of patches to
implement WAL decoding.
David Fetter sent in another revision of a patch to implement FILTER,
this time without the restriction that certain types of subqueries
couldn't be in the FILTER clause. Dean Rasheed sent in a patch on top
of same to make FILTER an unreserved word.
Alexander Korotkov sent in a patch to fix an irregularity in trigram
Andres Freund sent in a WIP patch to fix a corner case in CASE.
Andrew Dunstan sent in a patch to fix pg_dump for foreign tables in
the pg_upgrade scenario.
Fabien COELHO sent in another revision of a patch to implement CREATE
Simon Riggs and Heikki Linnakangas traded patches to fix how hashes
work in some edge cases.
Fabien COELHO sent in another revision of a patch to implement pgbench
Noah Misch sent in another revision of a patch to make Windows behave
better with different encodings.
Sent via pgsql-announce mailing list ([email protected])
To make changes to your subscription: