== PostgreSQL Weekly News - January 20 2013 ==
The 6th annual Prague PostgreSQL Developers Day conference,
organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be
held on May 30, 2013 at Faculty of Mathematics and Physics, Charles
University (Malostranske namesti 25, Prague). The CfP is open until
April 14, 2013 info AT p2d2 DOT cz. More information in Czech is at
http://www.p2d2.cz/
== PostgreSQL Product News ==
MJSQLView Version 3.41, a Java-based UI which supports PostgreSQL, released.
http://dandymadeproductions.com/projects/MyJSQLView/
Ora2PG 10.1, a migration system for moving from Oracle to PostgreSQL, released.
http://ora2pg.darold.net/
pgBadger 2.3, a PostgreSQL log analyzer written in Perl, released:
http://dalibo.github.com/pgbadger/
pgFormatter v1.2, a SQL formatter/beautifier which supports keywords
from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL
keywords are not in the standard, released.
http://sqlformat.darold.net/
== PostgreSQL Jobs for January ==
http://archives.postgresql.org/pgsql-jobs/2013-01/threads.php
== PostgreSQL Local ==
The FOSDEM PGDay conference that will be held before FOSDEM in
Brussels, Belgium, on Feb 1st, 2013.
http://fosdem2013.pgconf.eu/
The first edition of the Australian PostgreSQL Day (PGDay.AU 2013)
will be held in Melbourne on February 4, 2013. Registration is free of
charge. Schedule and info:
http://2013.pgday.org.au/
Registration:
http://www.meetup.com/melpug
PyPgDay will be held on March 13th at the Santa Clara Convention
Center, the first day of PyCon. Info here:
http://wiki.postgresql.org/wiki/PyPgDay2013
Submit your proposal here by January 20, 2013:
http://tinyurl.com/PyPgDayCfP
PGDay NYC 2013 will be held on March 22, 2013 in New York City.
http://pgday.nycpug.org/
PostgreSQL Session will be held on March 28th, 2013 in Paris,
France. The Call for Papers is open.
http://www.postgresql-sessions.org/en/5/
PGCon 2013 will be held May 23-24 2013, in Ottawa at the University of
Ottawa.
http://www.pgcon.org/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 da...@fetter.org, German language
to p...@pgug.de, Italian language to p...@itpug.org. Spanish language
to p...@arpug.com.ar.
== Applied Patches ==
Alvaro Herrera pushed:
- Remove spurious space. Andres Freund
http://git.postgresql.org/pg/commitdiff/692079e5dcb3316a51d4cadc2eb2fc184b33518d
- Rework order of checks in ALTER / SET SCHEMA When attempting to move
an object into the schema in which it already was, for most objects
classes we were correctly complaining about exactly that (object is
already in schema); but for some other object classes, such as
functions, we were instead complaining of a name collision (object
already exists in schema). The latter is wrong and misleading, per
complaint from Robert Haas in
CA+TgmoZ0+gNf7RDKRc3u5rHXffP=qjqpzkgxb4bspz65k7q...@mail.gmail.com
To fix, refactor the way these checks are done. As a bonus, the
resulting code is smaller and can also share some code with Rename
cases. While at it, remove use of getObjectDescriptionOids() in
error messages. These are normally disallowed because of
translatability considerations, but this one had slipped through
since 9.1. (Not sure that this is worth backpatching, though, as it
would create some untranslated messages in back branches.) This is
loosely based on a patch by KaiGai Kohei, heavily reworked by me.
http://git.postgresql.org/pg/commitdiff/7ac5760fa283bc090c25e4ea495a0d2bb41db7b5
- Split out XLog reading as an independent facility. This new
facility can not only be used by xlog.c to carry out crash recovery,
but also by external programs. By supplying a function to read XLog
pages from somewhere, all the WAL reading can be used for completely
different purposes. For the standard backend use, the behavior
should be pretty much the same as previously. As for non-backend
programs, an hypothetical pg_xlogdump program is now closer to
reality, but some more backend support is still necessary. This
patch was originally submitted by Andres Freund in a different form,
but Heikki Linnakangas opted for and authored another design of the
concept. Andres has advanced the patch since Heikki's initial
version. Review and some (mostly cosmetics) changes by me.
http://git.postgresql.org/pg/commitdiff/7fcbf6a405ffc12a4546a25b98592ee6733783fc
- Accelerate end-of-transaction dropping of relations When relations
are dropped, at end of transaction we need to remove the files and
clean the buffer pool of buffers containing pages of those
relations. Previously we would scan the buffer pool once per
relation to clean up buffers. When there are many relations to
drop, the repeated scans make this process
