== WöchentlicherPostgreSQL Newsletter - 09. Mai2010

Der Originalartikel befindet sich unter:

http://www.postgresql.org/community/weeklynews/pwn20100509



== Wöchentlicher PostgreSQL Newsletter - 09. Mai 2010 ==

PostgreSQL 9.0 Beta 1 erschienen. Testen!
http://www.postgresql.org/developer/beta

Der Prager PostgreSQL Testtag findet am 21. Mai 2010 in Prag,
Tschechische Repuplik, statt.
http://www.nic.cz/page/747/test-the-new-beta-version-of-post gresql-in-the-c=
z.nic-laboratories/

Das neue Executive Komitee von PostgreSQLFr besteht aus Präsident
Jean-Christophe Arnu, Vizepräsident Cedric Villemain, Schatzmeister
Stephane Schildknecht und Sekretär Patrick Francelle. Mehr Details
unter:
http://www.postgresql.fr/asso:elections

== PostgreSQL Produkt Neuigkeiten ==

pgfincore 0.41, ein Set von Funktionen um das Low-Level Management von
Relationen, unter Zuhilfenahme von mincore, zu handhaben und um
den Cache Memory zu erforschen, ist erschienen.
http://pgfoundry.org/projects/pgfincore/

James W. Pye hat ein weiteres PL/Python3 publiziert.
http://python.projects.postgresql.org/backend/

RHQ 3.0.0.B05, ein Systemmanagement- und Monotoringwerkzeug welches auf
PostgreSQL läuft, ist erschienen.
http://rhq-project.org/

== PostgreSQL 9.0 Feature der Woche ==

Du kannst spaltenbasierte Trigger erstellen, also Trigger die nur
ausgelöst werden wenn sich die angegebenen Spalten ändern. Die Sy=
ntax,
wie in SQL:2008 beschrieben, ist CREATE TRIGGER trigger_name
(BEFORE|AFTER) UPDATE OF col1 [,col2...coln] ON tablename FOR EACH ROW
EXECUTE PROCEDURE trigger_function();

== PostgreSQL Jobs im Mai ==

http://archives.postgresql.org/pgsql-jobs/2010-05/threads.ph p

== PostgreSQL Lokal ==

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19.
http://www.pgcon.org/2010/registration.php

Registrierung für Open Source Bridge ist offen und Vorträge sind
veröffentlicht. Vom 1. bis 4. Juni in Portland, Oregon.
http://opensourcebridge.org/events/2010/proposals/

Michael Renner wird auf der AMOOCON, welche vom 4. bis 6. Juni 2010
stattfindet, sprechen.
http://www.amoocon.de/speakers/214

Das Southeast Linuxfest 2010 findet in Spartanburg, SC, USA am
12. und 13. Juni statt. Stände und Sponsoringmöglichkeiten sind
noch verfügbar.
http://southeastlinuxfest.org/

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.
http://www.oscon.com/oscon2010

== PostgreSQL in den News ==

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

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@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org.

== Angewandte Patches ==

Heikki Linnakangas committed:

- Add cross-reference from wal_level to hot_standby setting. Update
the PITR documentation to mention that you need to set wal_level to
'archive' or 'hot_standby', to enable WAL archiving. Per Simon
Riggs's request.

- In pgsql/doc/src/sgml/high-availability.sgml, change "literal" tag
to the more appropriate "firstterm", when describing what
"eventually consistent" means.

- In pgsql/doc/src/sgml/config.sgml, change wording so that you don't
need to understand that wal_levels form a hierarchy. Per Simon
Riggs's suggestion.

- In pgsql/src/backend/access/transam/xlog.c, need to hold
ControlFileLock while updating control file. Update
minRecoveryPoint in control file when replaying a parameter change
record, to ensure that we don't allow hot standby on WAL generated
without wal_level=3D'hot_standby' after a standby restart.

- In pgsql/doc/src/sgml/intarray.sgml, fix incorrect parameter tag in
docs, spotted by KOIZUMI Satoru.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/mvcc.sgml, remove spurious dot, per bug #5446
reported by Koizumi Satoru.

Tom Lane committed:

- Fix backpatching error in recent patch for ALTER USER f RESET ALL
behavior. The argument list for array_set() changed in 8.2 (in
connection with allowing nulls in arrays) but the newer argument
list was used in the patches applied to 8.1 and 8.0 branches. The
patch for 7.4 was OK though. Per compiler warnings.

- In pgsql/src/bin/psql/psqlscan.l, fix psql to not go into infinite
recursion when expanding a variable that refers to itself (directly
or indirectly). Instead, print a message when recursion is
detected, and don't expand the repeated reference. Per bug #5448
from Francis Markham. Back-patch to 8.0. Although the issue exists
in 7.4 as well, it seems impractical to fix there because of the
lack of any state stack that could be used to track active
expansions.

- In pgsql/src/makefiles/Makefile.linux, on Linux, use
--enable-new-dtags when specifying -rpath to linker. This should
allow LD_LIBRARY_PATH to work as desired. Per trouble report from
Andy Colson.

- Work around a subtle portability problem in use of printf %s format.
Depending on which spec you read, field widths and precisions in %s
may be counted either in bytes or characters. Our code was assuming
bytes, which is wrong at least for glibc's implementation, and in
any case libc might have a different idea of the prevailing encoding
than we do. Hence, for portable results we must avoid using
anything more complex than just "%s" unless the string to be printed
is known to be all-ASCII. This patch fixes the cases I could find,
including the psql formatting failure reported by Hernan Gonzalez.
In HEAD only, I also added comments to some places where it appears
safe to continue using "%.*s".

- Adjust comments about avoiding use of printf's %.*s. My initial
impression that glibc was measuring the precision in characters
(which is what the Linux man page says it does) was incorrect. It
does take the precision to be in bytes, but it also tries to
truncate the string at a character boundary. The bottom line
remains the same: it will mess up if the string is not in the
encoding it expects, so we need to avoid %.*s anytime there's a
significant risk of that. Previous code changes are still good, but
adjust the comments to reflect this knowledge. Per research by
Hernan Gonzalez.

- In pgsql/doc/src/sgml/ecpg.sgml, fix typo: PGTYPES_NUM_OVERFLOW
should be PGTYPES_NUM_UNDERFLOW. Noted by KOIZUMI Satoru.

- In pgsql/src/backend/replication/walsender.c, fix missing static
declaration for XLogRead().

- In pgsql/src/bin/psql/print.c, suppress signed-vs-unsigned-char
warning.

ITAGAKI Takahiro committed:

- In pgsql/src/port/chklocale.c, code page for EUC-KR is surely 51949.

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/ecpglib/connect.c, ECPG connect routine
only checked for NULL to find empty parameters, but user and
password can also be "".

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Pavel Stehule sent in a patch to remove the limit on the number of
parameters passed to xslt_process() in contrib/xml2. It had been 10.

Simon Riggs sent in a WIP patch to change max_standby_delay to rely on
WAL receipt timestamp instead of log timestamp, per suggestion from
Tom Lane.

Pavel Stehule sent in a patch to add new optional arguments to
string_to_array() and array_to_string() which allow for an explicit
NULL string rather than to have NULL disappear unconditionally.

Peter Eisentraut sent in a patch to fix bug 5447, which relates to
VPATH builds.

Simon Riggs sent in a patch intended to fix the issue where Hot
Standby/Streaming Replication databases have slower queries on
replicas than origin.

Pavel Stehule sent in a patch to create to_string() and to_array()
functions which include NULL handling different from the current
"eliminate NULLs" behavior of array_to_string() and string_to_array().

Andy Lester and Robert Haas traded patches to clarify some CLUSTER
behavior.

Joel Jacobson and ITAGAKI Takahiro traded patches to add some new stat
transaction views for 9.1.

Nikhil Sontakke sent in two revisions of a patch intended to change
the behavior of memory with set-returning functions.

Simon Riggs sent in a patch intended to fix some behavior with Hot
Standby.

Simon Riggs sent in a patch to add a SQLSTATE for Hot Standby.

Robert Haas sent in a patch to avert doom around temprels.

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

--=20
Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein