== PostgreSQL Weekly News - April 11 2010 ==

== PostgreSQL Weekly News - April 11 2010 ==

== PostgreSQL Product News ==

Versions 1.2.21 and 2.0.3 of Slony1, a master-slave cascading
replication system for PostgreSQL, released.
http://www.slony.info/

Postgre-XC, a synchronous multi-master cluster for PostgreSQL, released.
https://sourceforge.net/projects/postgres-xc/

py-postgresql version 1.0, a pure Python 3 driver for PostgreSQL, released.
http://python.projects.postgresql.org/docs/1.0/changes.html

ODBC-Link 1.0, and ODBC-based database link system, released.
http://www.cybertec.at/en/postgresql_downloads

== PostgreSQL 9.0 Feature of the Week ==

You can now GRANT and REVOKE on objects schema-wide in a single
command.

== PostgreSQL Jobs for April ==

http://archives.postgresql.org/pgsql-jobs/2010-04/threads.php

== PostgreSQL Local ==

The CfP is open for CHAR(10) in Oxford, England on July 1-3 2010.
Proposals are due April 20.
http://www.char10.org

Bruce Momjian will be speaking about PostgreSQL Replication Solutions
at the NYPUG meeting on April 20th at 6:30-8:30pm at Penn Plaza.
Details and RSVP below.
http://postgresql.meetup.com/3/calendar/12788352/

Linuxfest Northwest 2010 will take place in Bellingham, Washington,
USA on April 24 and 25. Session, Booth and Sponsorship are available.
http://linuxfestnorthwest.org/

Andreas (ads) Scherbaum will be teaching a "PostgreSQL for Corporate
Use" course at the adult education center in Magdeburg, Germany May
3-7, 2010. Details below:
http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html

PgCon 2010 will be held May 20-21 2010 in Ottawa with tutorials before
on the 18th and 19th.
http://www.pgcon.org/2010/registration.php

The CfP for OSBridge is open! OSBridge will be June 1-4, 2010 in
Portland, Oregon.
http://opensourcebridge.org/events/2010/proposals/

Southeast Linuxfest 2010 will take place in Spartanburg, SC, USA on
June 12-13.  Booths and sponsorships are still available.
http://southeastlinuxfest.org/

OSCON will take place in Portland, Oregon July 19-23, 2010.
http://www.oscon.com/oscon2010

== 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(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot) Spanish language
to pwn(at)arpug(dot)com(dot)ar(dot)

== Applied Patches ==

ITAGAKI Takahiro committed:

- Assorted tab-completion improvements in psql. Added missing
completions for ALTER SEQUENCE name OWNER TO, ALTER TYPE name RENAME
TO, ALTER VIEW name ALTER COLUMN, ALTER VIEW name OWNER TO, and
ALTER VIEW name SET SCHEMA. Fix wrong completions for ALTER
FUNCTION/AGGREGATE name (arguments) where the "arguments" part was
ignored, and ALTER ... SET SCHEMA, where "SCHEMA" was considered to
be a variable name.

- In pgsql/src/bin/pg_ctl/pg_ctl.c, add cygwin version check before
using cygwin_conv_path(), and use cygwin_conv_to_full_win32_path()
in older versions.

- In pgsql/src/bin/psql/tab-complete.c, psql tab completion for ALTER
DEFAULT PRIVILEGES and USER MAPPING FOR PUBLIC.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ddl.sgml, reword exclusion constriants to
mention that the operator can return false or null, per Tom.

Simon Riggs committed:

- Change some debug ereports to elogs, as requested by translation
team.

- In pgsql/src/backend/access/transam/xlog.c, further message changes
when recovery.conf parameters missing.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/recovery.conf.sample, rename
"Log-streaming replication parameters" header to "Standby server
parameters" in recovery.conf, to match the grouping in the
documentation. Fujii Masao.

- Forbid using pg_xlogfile_name() and pg_xlogfile_name_offset() during
recovery. We might want to relax this in the future, but
ThisTimeLineID isn't currently correct in backends during recovery,
so the filename returned was wrong. Fujii Masao.

- Allow quotes to be escaped in recovery.conf, by doubling them. This
patch also makes the parsing a little bit stricter, rejecting
garbage after the parameter value and values with missing ending
quotes, for example.

Magnus Hagander committed:

- In pgsql/src/timezone/pgtz.c, log the actual timezone name that we
fail to look up the values for in case the registry data doesn't
follow the format we expect, to facilitate debugging.

- In pgsql/src/timezone/pgtz.c, proceed to look for the next timezone
when matching a localized Windows timezone name where the
information in the registry is incomplete, instead of aborting.
This fixes cases when the registry information is incomplete for a
timezone that is alphabetically before the one that is in use. Per
report from Alexander Forschner

- In pgsql/src/timezone/pgtz.c, update list of Windows timezones we
try to match localized names against to one that's up to date with
Windows 2003R2.

- In pgsql/src/timezone/pgtz.c, clean up inconsistent commas.

- Perltidy run over the MSVC build system files, to clean up code
formatting and indentation styles.

Tom Lane committed:

- Fix to_char YYY, YY, Y format codes so that FM zero-suppression
really works, rather than only sort-of working as the previous
attempt had left it. Clean up some unnecessary differences between
the way these were coded and the way the YYYY case was coded.
Update the regression test cases that proved that it wasn't working.

Robert Haas committed:

- Make smart shutdown work in combination with Hot Standby/Streaming
Replication. At present, killing the startup process does not
release any locks it holds, so we must wait to stop the startup and
walreceiver processes until all read-only backends have exited.
Without this patch, the startup and walreceiver processes never
exit, so the server gets permanently stuck in a half-shutdown state.
Fujii Masao, with review, docs, and comment adjustments by me.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Simon Riggs sent in two revisions of a patch to downgrade a FATAL
message to a WARNING for hot standby when primary_conninfo or
restore_command are left out.

Greg Sabino Mullane sent in a patch to show schema name for each table
when REINDEX DATABASE is called.

Simon Riggs sent in a patch for Hot Standby to recover prepared
transactions when starting up from shutdown.

Heikki Linnakangas sent in a patch to add signaling between
walreceiver and startup process.

Heikki Linnakangas sent in a patch to keep a variable in shared memory
to track the latest removed WAL segment. This can help with streaming
replication in the case of a "disk full" condition on the primary.

Heikki Linnakangas sent in a patch to fix unsafe threading for
syslogger on Windows.

Simon Riggs and Heikki Linnakangas traded patches to fix the issue
where Hot Standby doesn't work right with shutdowns at an inopportune
moment.

Jaime Casanova sent in a WIP patch to fix "make standbycheck".