== Wöchentlicher PostgreSQL Newsletter - 01. Februar 2009 ==

Der Originalartikel befindet sich unter:
http://www.postgresql.org/community/weeklynews/pwn20090201

== Wöchentlicher PostgreSQL Newsletter - 01. Februar 2009 ==

Bugfix Releases für 8.3, 8.2, 8.1, 8.0 und 7.4 werden in Kürze
erscheinen. Fertigmachen zum Upgrade!

Greg Smith hat Version 0.90 von pgtune auf pgfoundry veröffentlicht.
http://pgfoundry.org/projects/pgtune/

Die bulgarische PostgreSQL User Gruppe wird sich am 12. Februar 2009 um
19 Uhr im Vinarnata, 19 Lavele str in Sofia treffen.
http://www.doodle.com/participation.html?pollId=vb788q7v8ybi4z39

== PostgreSQL Produkt Neuigkeiten ==

Archiveopteryx 3.0.6, ein Mailsystem basierend auf PostgreSQL, ist
erschienen.
http://www.archiveopteryx.org/3.0.6

Pgbuildfarm 3.2 Client Code ist erschienen. Upgrade!
http://pgfoundry.org/frs/download.php/2069/build-farm-3_2.tgz

== PostgreSQL Tipp der Woche ==

Muss nur ein Teil der Tabelle Unique sein, z. B. nur die Benutzernamen
der aktiven User? Dann nutze einen partiellen Unique Index:
CREATE UNIQUE INDEX ON logins ( username ) WHERE active = true;

== PostgreSQL Lokal ==

Richard Broersma koordiniert die Standhelfer für SCALE (siehe unten).
Kontaktiere ihn unter richard DOT broersma AT gmail DOT com.

SYDPUG wird sich am 3. Februar 2009 um 18:30 Uhr bei Fujitsu
Australia in Nord Sydney treffen. Mark Leslie wird über die Geschichte
und Motivationen von PostGIS sprechen.
http://archives.postgresql.org/sydpug/2009-01/msg00000.php

Viele der üblichen Verdächtigen werden auf der FOSDEM am 7. und 8.
Februar in Brüssel, Belgien sein. Mehr Informationen und der Zeitplan
sind verfügbar unter:
http://wiki.postgresql.eu/wiki/FOSDEM_2009

JNBPUG trifft sich am 9. Februar um 19:00 Uhr im News Cafe in der
New Road in Midrand.

Stephen Frost wird über Column-Level Permissions bei der BWPUG sprechen,
am 9. Februar um 18:30 Uhr in den OmniTI Büros.
http://pugs.postgresql.org/bwpug

Der Prager PostgreSQL Entwicklertag 2009 findet am 12. Februar statt.
http://www.postgresql.org/about/event.808
Zeitplan:
http://www.postgres.cz/p2d2/2009/sched_en.html

SFPUG präsentiert: Reece Hart von Unison DB für rechenbetonte Biologie
am 10. Februar 2009, der Ort wird noch bekannt gegeben.
http://postgresql.meetup.com/1/calendar/9351228/

PostgreSQL wird auf der SCALE vom 20. bis 22. Februar in Los Angeles
vertreten sein.
http://www.socallinuxexpo.org/

Andreas 'ads' Scherbaum wird einen Vortrag auf dem Perl Workshop 2009
am 25. Februar in Frankfurt am Main, Deutschland, halten.
http://www.perl-workshop.de/talks/151/view

PostgreSQL Conference U.S. wird einen PgDay auf dem Linuxfest Nordwest
am 25. und 26. April veranstalten. Der Call for Papers ist unter:
http://www.postgresqlconference.org/

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.
http://www.pgcon.org/2009/papers.php

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.

== PostgreSQL in den News ==

Planet PostgreSQL: http://planet.postgresql.org/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Josh Berkus.

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:

- Message format tuning in ecpg.

- Revert updatable views.

- Message fix in pgsql/src/interfaces/ecpg/preproc/parse.pl

- Translation updates.

- In pgsql/src/interfaces/ecpg/preproc/ecpg.c, whitespace fix in
message.

- In ecpg, Make messages consistent with existing ones.

Alvaro Herrera committed:

- Allow extracting and parsing of reloptions from a bare pg_class
tuple, and refactor the relcache code that used to do that. This
allows other callers (particularly autovacuum) to do the same
without necessarily having to open and lock a table.

Magnus Hagander committed:

- In pgsql/src/backend/utils/adt/pg_locale.c, silence compiler
warnings in new win32 locale code when building on mingw. ITAGAKI
Takahiro.

- In pgsql/src/test/regress/pg_regress.c, silence compiler warning on
win32. ITAGAKI Takahiro

- In pgsql/src/bin/pg_ctl/pg_ctl.c, support running as a service on
Windows 7, by not specifying the JOB_OBJECT_UILIMIT_HANDLES flag.
Dave Page & Magnus Hagander

- Go over all OpenSSL return values and make sure we compare them to
the documented API value. The previous code got it right as it's
implemented, but accepted too much/too little compared to the API
documentation. Per comment from Zdenek Kotala.

- In pgsql/src/test/regress/pg_regress.c, change warning-silencing
code not to cast the pointer type, instead casting the value of the
variable later. Per comments from Tom Lane.

Teodor Sigaev committed:

- In pgsql/contrib/tsearch2/tsearch2.c, fix bug with multiple
evaluation of tsearch2 compatibility trigger, trigger data should be
restored. Backpatch only to 8.3 because previous versions don't
have such layer.

- In pgsql/src/backend/tsearch/spell.c, fix incorrect dereferencing of
char* to array's index. Per report from Tommy Gildseth.

Tom Lane committed:

- Replace argument-checking Asserts with regular test-and-elog checks
in all encoding conversion functions. These are not can't-happen
cases because it's possible to create a conversion with the wrong
conversion function for the specified encoding pair. That would
lead to an Assert crash in an Assert-enabled build, or incorrect
conversion otherwise, neither of which is desirable. This would be
a DOS issue if production databases were customarily built with
asserts enabled, but fortunately that's not so. Per an observation
by Heikki. Back-patch to all supported branches.

- Update time zone data files to tzdata release 2009a: introduces
Asia/Kathmandu as the preferred spelling of that zone name, corrects
historical DST information for Switzerland and Cuba.

- In pgsql/doc/src/sgml/release.sgml, update back-branch release
notes.

- Defend against null input in analyze_requires_snapshot(), per report
from Rushabh Lathia. Back-patch of patch of 2009-01-08. This is
necessary in 8.3, as reported by Bjorn Munch. It's not currently
necessary in 8.2, AFAICS, but seems best to include it there too.

- In pgsql/src/backend/utils/adt/arrayfuncs.c, fix unnest() to handle
a toasted input array safely. Per report from Alvaro Herrera.

Heikki Linnakangas committed:

- Check that connection limit is within valid range. IOW, not < -1.
It's missing in older versions too, but it doesn't seem worth
back-porting. All negative are just harmlessly treated as "no
limit", and tightening the check might even brake an application
that relies on it.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

KaiGai Kohei sent in another revision of his SE-PostgreSQL patch.

KaiGai Kohei sent in two doc patches atop his SE-PostgreSQL patches.

Brendan Jurd sent in an updated patch to correct the meridiem markers.

Zdenek Kotala sent in another revision of his space reservation patch.

Fujii Masao sent in another revision of the synchronous replication
patch.

Simon Riggs sent in a bug fix atop the Hot Standby patch.

Heikki Linnakangas sent in two more revisions of the Recovery
Infrastructure patch.

Kenneth Marshall sent in another revision of the updated hash
functions patch.

Timo Savola sent in a patch which allows people to set a sample
percentage for logging.

Alvaro Herrera sent in two more revisions of his patch to add
namespaces to reloptions.

Fernando Ike de Oliveira sent in a patch to add \dL, which lists
languages, to psql.

Andrew Dunstan sent in another revision of his parallel pg_dump patch.

Euler Taveira de Oliveira sent in two patchs atop Alvaro Herrera's
reloptions patch.

Hiroshi Saito sent in three revisions of a patch to generate a
.def (DLL symbol export) file for the event log plugin on mingw.

Robert Haas sent in a patch to optimize add_path in the planner.

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