== Wöchentlicher PostgreSQL Newsletter - 24. Mai 2009 ==

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

== Wöchentlicher PostgreSQL Newsletter - 24. Mai 2009 ==

PostgreSQL 8.1 Beta 2 erschienen. Testen!
http://www.postgresql.org/developer/beta

PgCon war ein großer Erfolg, mit einer gesteigerten Besucherzahl im
Angesicht von wenigern Besuchern auf anderen Konferenzen. Das Video
zur Konferenz erscheint demnächst.
http://www.pgcon.org/2009/

Das Video vom SFPUG Treffen am 12. Mai 2009, "BIRT & PostgreSQL", ist
jetzt zum Anschauen und Herunterladen auf media.postgresql.org
verfügbar.
http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov

Die 10. jährliche JPUG Konferenz hat den Call for Proposals gestartet.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

MicroOLAP Database Designer 1.2.8 Beta1, ein Windows-basierender
Designer für PostgreSQL, ist erschienen.
http://microolap.com/products/database/postgresql-designer/

Die PostgreSQL/PostGIS Community wird sich am 6. Juni 2009 in Zürich
treffen. Details (in de_CH) unter:
http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-Höck

== PostgreSQL Produkt Neuigkeiten ==

== PostgreSQL 8.4 Feature der Woche ==

Warm Standby: Wenn dich das Aufsetzen eines Warm Standby Servers vorher
verwirrt hat, dann gib 8.4 eine Chance; das ist viel
benutzerfreundlicher.

== PostgreSQL Tipp der Woche ==

Bis in 8.4 die Common Table Expressions und in 8.5 das SQL/MED
erscheint, kannst du das "tablefunc" Contrib Modul nutzen, um mittels
connect_by() Joins und Anfragen zwischen verschiedenen Datenbanken
oder der gleichen Datenbank zu nutzen.

== PostgreSQL Jobs im Mai ==

http://archives.postgresql.org/pgsql-jobs/2009-05/threads.php

== PostgreSQL Lokal ==

PGDay Junin / Buenos Aires Unnoba wird am 6. Juni 2009 stattfinden.
http://www.arpug.com.ar/trac/wiki/PgDayUnnoba

Termin vormerken: pgDay San Jose, am Sonntag dem 19. Juli unmittelbar
vor der OSCON. CfP und mehr Informationen bald.

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

PGDay.EU 2009 wird an der Telecom ParisTech Universität in Paris,
Frankreich, am 6. und 7. Nivember 2009 stattfinden.
http://www.pgday.eu/

== 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:

- Some documentation cleanup for the addition of the KOI8U encoding.
Change all (remaining) mentions of KOI8 to the new canonical form
KOI8R. Add information about the available conversions for KOI8U.

- Refer to tables by id, not by "the following table", because tables
are in theory floating elements.

- In pgsql/src/backend/catalog/sql_features.txt, update SQL
conformance entries for window functions functionality

- In pgsql/src/tools/editors/emacs.samples, add some instructions on
how to customize emacs for working on the SGML sources.

- Add documentation string for LDFLAGS_SL in configure --help output.

- In pgsql/src/tools/editors/emacs.samples, fix sgml-mode example.
Thanks, Andrew Dunstan.

- In pgsql/src/bin/pg_dump/pg_dump.c, convert some messages to use
ngettext(). Author: Euler Taveira de Oliveira.

Tom Lane committed:

- In pgsql/src/interfaces/libpq/fe-connect.c, make pwdfMatchesString()
a little more careful about matching * fields.

- Fix bug #4814 (wrong subscript in consistent-function call), and add
some minimal regression test coverage for matchPartialInPendingList().

- Fix LIKE's special-case code for % followed by _. I'm not entirely
sure that this case is worth a special code path, but a special code
path that gets the boundary condition wrong is definitely no good.
Per bug #4821 from Andrew Gierth. In passing, clean up some minor
code formatting issues (excess parentheses and blank lines in odd
places). Back-patch to 8.3, where the bug was introduced.

- Use more-portable coding for the check on handing out the last
available relopt_kind value in add_reloption_kind(). Per Zdenek
Kotala.

Heikki Linnakangas committed:

- In pgsql/src/backend/commands/analyze.c, update relpages and
reltuples estimates in stand-alone ANALYZE, even if there's no
analyzable attributes or indexes. We also used to report 0 live and
dead tuples for such tables, which messed with autovacuum threshold
calculations. This fixes bug #4812 reported by George Su. Backpatch
back to 8.1.

- In pgsql/src/backend/commands/tablecmds.c, silence a gcc compiler
warning about non-literal format string with no args when compiling
with -Wformat-security. Fujii Masao.

Michael Meskes committed:

- Removed some unneeded variables and comparisons.

- More variables gcc moans about.

- Removed unsigned/signed mismatches.

- Removed comparison of unsigned expression < 0.

Teodor Sigaev committed:

- In pgsql/src/backend/utils/adt/tsvector.c, re-sort tsvector's
lexemes in tsvectorrecv instead of emitting an error. Basically,
it's needed to support binary dump from 8.3 because the ordering
rule was changed. Per discussion with Bruce Momjian.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Simon Riggs sent in two patches to improve read-only scalability.

Pavel Stehule sent in another revision of the GROUPING SETS patch.

Jim Nasby sent in a patch to add a feature to vacuumdb that allows
analyze-only as an option.

Robert Haas sent in a patch to add parenthesized options to EXPLAIN.

Pavel Stehule sent in a patch to clean up some syntax warnings in
tsquery_op.c

Zdenek Kotala sent in two patches to do some cleanup to help
pg_migrator.

Tatsuhito Kasahara sent in a patch to fix ja.po.

Steve Prentice sent in two versions of a patch to supplement Pavel
Stehule's patch for named and mixed notation support in 8.5. Pavel
sent in a followup that touches the main parser. Steve sent an
updated patch.

Dimitri Fontaine sent in a document patch for GiST extensions.

Adriano Lange sent in a patch implementing 2PO, an alternative to
the GEQO for optimizing large joins.

Andres Freund sent in a patch to allow EXPLAIN ANALYZE to show
counts of discarded tuples.

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