== Postgres Weekly News - December 23 2007 ==

== Postgres Weekly News - December 23 2007 ==

== Postgres Product News ==

Nagios plugin check_postgres 1.1.0 released.
http://bucardo.org/nagios_postgres/

Npgsql 2 Beta2 released.
http://pgfoundry.org/projects/npgsql/

phpPgAdmin 4.2 beta 1 released.
http://phppgadmin.sourceforge.net/

ptop 3.6.1 beta 2 released.
http://ptop.projects.postgresql.org/

== Postgres Jobs for December ==

http://archives.postgresql.org/pgsql-jobs/2007-12/threads.php

== Postgres Local ==

PGCon 2008 will be May 20-23 in Ottawa - now accepting proposals.
http://www.pgcon.org/2008/papers.php

The BSD and PostgreSQL teams share a developer room at FOSDEM 2008 in
Brussels February 23-34, 2008. If you want to give a talk or help
managing the dev room, contact fosdem(at)pgug(dot)eu(dot) For more information,
see:
http://fosdem.org/2008/schedule/devroom/bsdpostgresql

PostgreSQL Conference East '08 talks are March 29 and 30 at the
University of Maryland, College Park.
http://www.postgresqlconference.org/

FISL 9.0 will be happening April 17-19, 2008 at PUCRS in Porto Alegre,
Brazil. Talk proposals are due by January 11, 2008.
https://fisl.softwarelivre.org/9.0/

== Postgres in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

Postgres 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)

== Applied Patches ==

Michael Meskes committed:

- In ecpg, fixed a few minor glitches pointed out by splint.

Magnus Hagander committed:

- Make all msvc build scripts use buildenv.pl, not buildenv.bat.
Andrew Dunstan

- In pgsql/src/tools/msvc/clean.bat, remove unnecessary logo output
from msbuild when cleaning ecpg regression test outputs.

- On win32, loop when opening files if sharing- or lock-violation
errors occur. Hopefully, this will make it possible to recover from
broken antivirus and/or backup software that locks our files.

- In pgsql/src/interfaces/libpq/Makefile, libpq needs pgsleep on win32
because of the changes to port/open.c.

Andrew Dunstan committed:

- In pgsql/src/backend/utils/adt/oracle_compat.c, fix thinko in
encoding check for chr().

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/runtime.sgml, improve wording re: OOM killer.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/backup.sgml, update archive_command example to
use || test, rather than if [].

- Remove tab in SGML file.

- Update pg_ctl/kill docs.

- Modify pgindent to use an external typedefs file rather than
included list. Remove pgjindent.

- In pgsql/src/tools/find_typedef, update find_typedefs to handle
simple 'typedef X' cases, per request from Tom Lane.

- Remove paragraph about Linux OOM killer and fork(). Instead link to
article about OOM.

- In pgsql/doc/src/sgml/runtime.sgml, properly indent SGML paragraph.

Tom Lane committed:

- Some desultory copy-editing on the backup/restore docs.

- Make path_recv() and poly_recv() reject paths/polygons containing no
points. The zero-point case is sensible so far as the data
structure is concerned, so maybe we ought to allow it sometime; but
right now the textual input routines for these types don't allow it,
and it seems that not all the functions for the types are prepared
to cope. Report and patch by Merlin Moncure. Back-patched to 7.4.

- Make archiver process report its progress in PS display. Per
proposal by Simon Riggs, though not exactly his patch.

- When given a nonzero column number, pg_get_indexdef() is only
supposed to print the index key variable or expression for that
column. It was mistakenly printing ASC/DESC/NULLS FIRST/NULLS LAST
decoration too --- and not only for the target column, but all
columns. Someday we should have an option to extract that info (and
the opclass decoration as well) for a single index column ... but
today is not that day. Per bug #3829 and subsequent discussion.

- In pgsql/doc/src/sgml/func.sgml, fix a small typo, per Jan Urbanski.

== Rejected Patches (for now) ==

Gokulakannan Somasun's patch for NULL bitmap optimization on grounds
of lack of evidence for its efficacy and correctness.

== Pending Patches ==