Skip to content

Wöchentlicher PostgreSQL Newsletter - 31. Mai 2009


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


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

== PostgreSQL Produkt Neuigkeiten ==

Version 1.0 von Sonar, eine Open Source Plattform zum Management der
Source Code Qualität, unterstützt jetzt PostgreSQL.
http://sonar.codehaus.org/

== PostgreSQL 8.4 Feature der Woche ==

array_agg(): der SQL-Standard Weg um Werte in ein Array zu aggregieren.
Jetzt offiziell enthalten - und außerdem schneller.

== PostgreSQL Tipp der Woche==

Wenn deine aggregierten Anfragen langsam sind, versuch work_mem zu
erhöhen.

== PostgreSQL Jobs im Juni ==

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

== PostgreSQL Lokal ==

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

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

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/

Die 10. jährliche JPUG Konferenz hat den Aufruf für Vorträge gestartet.
Die Konferenz findet am 20-21. November 2009 in Tokio, Japan, statt.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

== PostgreSQL in den News ==

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

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

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



== Angewandte Patches ==

Tom Lane committed:

- Add range checks to time_recv() and timetz_recv(), to prevent binary
   input of time values that would not be accepted via textual input.
   Per gripe from Andrew McNamara.  This is potentially a
   back-patchable bug fix, but for the moment it doesn't seem
   sufficiently high impact to justify doing that.

- Remove unused declarations of EncodeTimeOnly and DecodeTimeOnly.

- Allow the second argument of pg_get_expr() to be just zero when
   deparsing an expression that's not supposed to contain variables.
   Per discussion with Gevik Babakhani, this eliminates the need for an
   ugly kluge (namely, specifying some unrelated relation name).
   Remove one such kluge from pg_dump.

- Remove the useless and rather inconsistent return values of
   EncodeDateOnly, EncodeTimeOnly, EncodeDateTime, EncodeInterval.
   These don't have any good reason to fail, and their callers were
   mostly not checking anyway.

- Improve documentation about function volatility: mention the
   snapshot visibility effects in a couple of places where people are
   likely to look for it.  Per discussion of recent question from Karl
   Nack.

- Ignore RECHECK in CREATE OPERATOR CLASS, just throwing a NOTICE,
   instead of throwing an error as 8.4 had been doing.  The error
   interfered with porting old database definitions (particularly for
   pg_migrator) without really buying any safety.  Per bug #4817 and
   subsequent discussion.

- In pgsql/doc/src/sgml/release-8.4.sgml, improve release note
   explanation of the change in libpq's handling of default usernames
   versus Kerberos tickets.  Per confusion about what bug #4824 was
   really about.

- In pgsql/src/backend/catalog/index.c, update obsolete comment in
   index_drop().  When the comment was written, queries frequently took
   no lock at all on individual indexes.  That's not true any more, but
   we still need lock on the parent table to make it safe to use cached
   lists of index OIDs.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/backup.sgml, remove tabs from SGML file.

- In pgsql/doc/src/sgml/libpq.sgml, document that forking while having
   open libpq connections is not advised.

Michael Meskes committed:

- In pgsql/src/interfaces/libpq/fe-exec.c, reverting patch just in
   case a compiler treats this enum as signed.

- Change macros to make gcc quiet when parsing.

Peter Eisentraut committed:

- Fix compiler warnings on Sun Studio of the sort '"tsquery_op.c",
   line 193: warning: syntax error: empty declaration.'  Zdenek Kotala.

- Fix to use the same format specifiers in both branches of a
   ngettext().  Zdenek Kotala.

Magnus Hagander committed:

- In pgsql/src/backend/libpq/auth.c, properly return the usermap
   result when doing gssapi authentication.  Without this, the username
   was in practice never matched against the kerberos principal used to
   log in.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/xlog.c, when archiving is
   enabled, rotate the last WAL segment at shutdown so that all
   transactions are archived.  Original patch by Guillaume Smet.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options