== Wöchentlicher PostgreSQL Newsletter - 24. Februar 2008 ==

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/index.php?/archives/160-Postgres-Weekly-News-February-24-2008.html

== Wöchentlicher PostgreSQL Newsletter - 24. Februar 2008 ==

FOSDEM war ein durchschlagender Erfolg für PostgreSQL. Bei den
Vorträgen mussten Leute häufig sogar stehen; die Leute am Stand waren
enthusiastisch und fachkundig, die Spenden waren teilweise sehr hoch.
Danke schön an alle, die dies möglich gemacht haben.

Die Europäische PostgreSQL Usergruppe hat nun ein Board of Directors:
Jean-Paul Agudo aus Frankreich, Gabriele Bartolini aus Italien, Magnus
Hagander aus Schweden und Andreas Scherbaum aus Deutschland. Herzlichen
Glückwunsch an alle!

== PostgreSQL Produkt Neuigkeiten ==

Benetl 1.5 für Windows erschienen.
http://www.benetl.net

Pg::Snapshot und Materialized Views Version 0.3.2 erschienen.
http://pgfoundry.org/projects/snapshot/

Peter Eisentraut und andere haben das Debian PostgreSQL Packaging
Projekt gestartet.
http://pkg-postgresql.alioth.debian.org/

Greg Sabino Mullane hat MediaWiki mit PostgreSQL 8.3 kompatibel gemacht.
http://people.planetpostgresql.org/greg/index.php?/archives/123-MediaWiki-is-Postgres-8.3-compatible.html

MicroOLAP Database Designer 1.2.3 für PostgreSQL erschienen.
http://microolap.com/products/database/postgresql-designer/

Nagios Plugin für Postgres 1.2.0 erschienen.
http://bucardo.org/nagios/

PGCluster Pakete 1.9, 1.7, 1.5 und 1.3 aktualisiert.
http://pgfoundry.org/projects/pgcluster/

ptop 3.6.1 Beta4 erschienen.
http://ptop.projects.postgresql.org/

textsearch-ja 8.3.0 erschienen.
http://pgfoundry.org/projects/textsearch-ja/

VTD-XML 2.3 erschienen.
http://sourceforge.net/project/showfiles.php?group_id=110612&package_id=120172

== PostgreSQL Jobs im Februar ==

http://archives.postgresql.org/pgsql-jobs/2008-02/threads.php

== PostgreSQL Lokal ==

Der PG UK Tag wird am 2. April in Birmingham sein.
http://www.postgresql.org.uk/

PGCon 2008 wird vom 20. bis 23. Mai in Ottawa sein.
http://www.pgcon.org/2008/papers.php

PostgreSQL Conference East '08 ist am 29. und 30. März an der
Universität von Maryland, College Park.
http://www.postgresqlconference.org/

Die FISL wird vom 17. bis 19. April 2008 auf der PUCRS in Porto Alegre,
Brasilien, stattfinden.
https://fisl.softwarelivre.org/9.0/

== PostgreSQL in den News ==

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

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Peter Eisentraut committed:

- In pgsql/src/backend/tsearch/Makefile, observe errors.

- Added --htmldir option to pg_config, equivalent to the new configure
option.

- Refactor backend makefiles to remove lots of duplicate code.

- In pgsql/src/backend/access/common/Makefile, remove another target I
forgot during the refactoring.

- Remove pgsql/src/backend/port/sunos4. This subdirectory has been
unused, dead, and broken for 10 years.

- More refactoring, so that the SUBSYS.o rules are now all in one
place.

- Backport fixed AC_FUNC_FSEEKO

Bruce Momjian committed:

- autoconf 2.61's AC_FUNC_FSEEKO reports success/failure differently,
so reorganize code for NetBSD/BSDi port/fseeko.c usage, and make
code more modular.

- Put fseeko check back in old location, in hopes of silencing build
warnings.

- Put back code modularization of fseeko() configure checks.

Tom Lane committed:

- Remove unnecessary opening of other relation in
RI_FKey_keyequal_upd_pk and RI_FKey_keyequal_upd_fk, as well as
no-longer-needed calls of ri_BuildQueryKeyFull. Aside from saving a
few cycles, this avoids needless deadlock risks when an update is not
changing the columns that participate in an RI constraint. Per a gripe
from Alexey Nalbat. Back-patch to 8.3. Earlier releases did have a
need to open the other relation due to the way in which they retrieved
information about the RI constraint, so this problem unfortunately
can't easily be improved pre-8.3. Tom Lane and Stephan Szabo

- In pgsql/src/backend/catalog/catalog.c, put a CHECK_FOR_INTERRUPTS
call into the loops that try to find a unique new OID or new
relfilenode. If the existing OIDs are sufficiently densely
populated, this could take a long time (perhaps even be an infinite
loop), so it seems wise to allow the system to respond to a cancel
interrupt here. Per a gripe from Jacky Leng. Backpatch as far as
8.1. Older versions just fail on OID collision, instead of looping.

- In pgsql/src/bin/pg_ctl/pg_ctl.c, fix mistakes in pg_ctl's code for
"start -w" that tries to cope with non-default settings for the
postmaster's port number. The code to parse command line options
and postgresql.conf entries wasn't quite right about whitespace or
quotes, and it was coded in a not-very-readable way too. Per bug
#3969 from Itagaki Takahiro, though this is more extensive than his
proposed patch (which fixed only the whitespace problem). This code
has been broken since it was put in in 8.0, so patch all the way
back.

- In pgsql/src/test/regress/pg_regress.c, make pg_regress -V
consistent with the corresponding code in other programs: use puts
with a compile-time-constant string.

- Rename miscadmin.h's PG_VERSIONSTR macro to PG_BACKEND_VERSIONSTR to
make it a bit clearer what it is, and get rid of duplicate
definitions in initdb and pg_ctl.

- Change the declaration of struct varlena so that the length word is
represented as "char ...[4]" not "int32". Since the length word is
never supposed to be accessed via this struct member anyway, this
won't break any existing code that is following the rules. The
advantage is that C compilers will no longer assume that a pointer
to struct varlena is word-aligned, which prevents incorrect
optimizations in TOAST-pointer access and perhaps other places. gcc
doesn't seem to do this (at least not at -O2), but the problem is
demonstrable on some other compilers. I changed struct inet as
well, but didn't bother to touch a lot of other struct definitions
in which it wouldn't make any difference because there were other
fields forcing int alignment anyway. Hopefully none of those struct
definitions are used for accessing unaligned Datums.

- In pgsql/src/backend/utils/misc/help_config.c, avoid trying to print
a NULL char pointer in --describe-config. On some platforms this
works, but on some it crashes. Zdenek Kotala

- Use our own getopt() and getopt_long() on Solaris, because that
platform's versions don't handle long options the way we want. Per
Zdenek Kotala.

Magnus Hagander committed:

- In pgsql/src/tools/msvc/Solution.pm, unbreak MSVC build after recent
addition of HTMLDIR.

- In pgsql/src/timezone/strftime.c, fix function prototype to silence
compiler warnings.

- In pgsql/src/tools/msvc/Project.pm, un-break msvc port yet again (it
started pulling in the Darwin port files, which obviously didn't
compile).

Alvaro Herrera committed:

- In pgsql/src/backend/postmaster/autovacuum.c, change error message
to be able to differentiate the two cases. Per suggestion from
Jaime Casanova.

- Improve error messages emitted when VACUUM and ANALYZE skip a table.
Per gripe from Clodoaldo Pinto Neto.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Gevik Babakhani sent in a patch to fix MSVC compilation on MSVC.

Tatsuhito Kasahara sent in two revisions of a patch intended to change
pgstatindex.c and pgstattuple.sql, where some variables are defined
with int type, to a larger numeric type, which in turn allows for
larger tables.

Davd Page sent in a patch which fixes initdb failures on Windows
stemming from recent security-related changes to that platform.

Zdenek Kotala sent in three revisions of a patch intended to fix
non-portable getopt() code.

Neil Conway sent in a patch to fix some memory leaks in the
implementaiton of set-returning functions.

Peter Eisentraut sent in a patch links the backend in one piece
instead of many SUBSYS.so files.

Robert Lor sent in a patch to change the DTrace probes from the
DTRACE_PROBEn implementation to the header macro implementation so
that the probes can be used on OSs other than Solaris including OSX
Tiger.

Heikki Linnakangas sent in an optimization for CopyReadLineText which
should speed up COPY operations in many common cases.

--
Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group: http://www.pgug.de
DPWN: http://ads.wars-nicht.de/blog/categories/18-PWN