== WöchentlicherPostgreSQL Newsletter - 12.April 2009

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


== Wöchentlicher PostgreSQL Newsletter - 12. April 2009 ==

Die Italienische PostgreSQL Usergruppe wird am Freitag, den 8. Mai
einen Überblick über PostgreSQLfür die Studenten der IT Fach=
schaft an
der Universität von Pisa geben.
http://www.postgresql.org/about/event.856

PgDay Florianopolis wird am 22. Mai stattfinden. Kontaktiere Dickson S.
Guedes (guedes AT guedesoft DOT net) um teilzunehmen oder einen Vortrag
einzureichen,
http://www.postgresql.org.br/eventos/pgday/sc

== PostgreSQL Produkt Neuigkeiten ==

py-postgresql 0.8, ein Cluster basierend auf Python Technologien für d=
ie
Nutzung innerhalb und außerhalb der PostgreSQL Engine, ist erschienen.
http://python.projects.postgresql.org/docs/0.8/

== PostgreSQL 8.4 Feature der Woche ==

psql ist jetzt "versions-bewusst", was bedeutet, dass die "Backslash"
Befehle jetzt auch funktionieren, wenn du zu einer älteren Server
Version mit einem 8.4 psql verbindest.

== PostgreSQL Tipp der Woche ==

Der einfachste Weg um doppelt vorhandene Zeilen in einer Tabelle
mit einem fehlenden Natural Key zu entfernen ist das Erstellen einer
neuen Tabelle mit CREATE TABLE AS ... GROUP BY. Danach werden die Daten
zurück in die ursprüngliche Tabelle kopiert. Und - ganz wichtig -=
der
Natural Key ist zu ersetzen!

== PostgreSQL Jobs im April ==

http://archives.postgresql.org/pgsql-jobs/2009-04/threads.ph p

== PostgreSQL Lokal ==

PgDay Brasilien wird am 17. April stattfinden. Kontaktiere fernando.ike
AT gmail DOT com oder eduardo DOT santos AT planejamento DOT gov DOT
br, wenn du teilnehmen möchtest.
http://www.postgresql.org.br/drupal6/eventos/pgday/df

Die Percona Performance Konferenz wird im Santa Clara Convention Center
in Santa Clara, Kalifornien, USA, stattfinden.
http://conferences.percona.com/

Der CfP für den PgDay in Sao Paulo am 24. April ist eröffnet.
Kontaktiere marins DOT consultoria AT gmail DOT com oder marcelojscosta
AT gmail DOT com wenn du teilnehmen möchtest.

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

Es werden weiterhin PgDays am 29. April in Porto Velho, RO und am 20.
April in Ji-Parana, RO stattfinden. Kontaktiere Luis Fernando Bueno:
proflfbueno AT gmail DOT com wenn du teilnehmen möchtest.

Michael Renner wird einen Workshop über PostgreSQL Replikation auf
der Netways OSDC 2009 in Nürnbern, Deutschland geben.
http://www.netways.de/english/osdc/y2009/programm/w/michael_ renner_postgres=
ql_repliziert_ein_ueberblick/

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/

PgDay Florianopolis wird am 22. Mai stattfinden. Kontaktiere Dickson S.
Guedes (guedes AT guedesoft DOT net) um teilzunehmen oder einen Vortrag
einzureichen,
http://www.postgresql.org.br/eventos/pgday/sc

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.

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

== Angewandte Patches ==

Heikki Linnakangas committed:

- Rename the new CREATE DATABASE options to set collation and ctype
into LC_COLLATE and LC_CTYPE, per discussion on pgsql-hackers.

- Tell gettext which codeset to use by calling
bind_textdomain_codeset(). We already did that on Windows, but it's
needed on other platforms too when LC_CTYPE=3DC. With other locales,
we enforce (or trust) that the codeset of the locale matches the
server encoding so we don't need to bind it explicitly. It should do
no harm in that case either, but I don't have full faith in the PG
encoding -> OS codeset mapping table yet. Per recent discussion on
pgsql-hackers.

- In pgsql/src/backend/utils/init/postinit.c, oops, mustn't call
textdomain() when compiling without --enable-nls

- Quote string literals correctly in the new CREATE SERVER statements
and binary upgrade UPDATE statements.

Teodor Sigaev committed:

- Fix 'all at one page bug' in picksplit method of R-tree emulation.
Add defense from buggy user-defined picksplit to GiST.

- Fix 'all at one page bug' in picksplit method of R-tree emulation.
Add defense from buggy user-defined picksplit to GiST.

Tom Lane committed:

- In pgsql/doc/src/sgml/keywords.sgml, correct keywords table for
status of COLLATE vs LC_COLLATE.

- In pgsql/doc/src/sgml/fuzzystrmatch.sgml, document the fact that
fuzzystrmatch doesn't work in multibyte encodings.

- Add an optional parameter to pg_start_backup() that specifies
whether to do the checkpoint in immediate or lazy mode. This is to
address complaints that pg_start_backup() takes a long time even
when there's no need to minimize its I/O consumption.

- In pgsql/contrib/fuzzystrmatch/fuzzystrmatch.c, defend against
non-ASCII letters in fuzzystrmatch code. The functions still don't
behave very sanely for multibyte encodings, but at least they won't
be indexing off the ends of static arrays.

- In pgsql/contrib/pg_freespacemap/pg_freespacemap.c, remove useless
(leftover?) extern declaration.

- Allow leading and trailing spaces around NaN in numeric_in. Sam
Mason, rewritten a bit by Tom Lane.

- Remove psql's ancient hack that suppressed functions taking or
returning cstring from the output of \df. Now that the default
behavior is to exclude all system functions, the de-cluttering
rationale for this behavior seems pretty weak; and it was always
quite confusing/unhelpful if you were actually looking for I/O
functions. (Not to mention if you were looking for encoding
converters or other cases that might take or return cstring.)

- Fix the plpgsql memory leak exhibited in bug #4677. That leak was
introduced by my patch of 2007-01-28 to use per-subtransaction
ExprContexts/EStates: since we re-prepared any expression tree when
the current subtransaction ID changed, we'd accumulate more and more
leaked expression state trees in the outermost subtransaction if the
same function was executed at multiple levels of subtransaction
nesting. To fix, go back to the previous scheme where there was
only one EState per transaction for simple plpgsql expressions. We
really only need an ExprContext per subtransaction, not a whole
EState, so it's possible to keep prepared expression state trees in
the one EState throughout the transaction. This should be more
efficient as well as not leaking memory for cases involving lots of
subtransactions. The added regression test is the case that
inspired the 2007-01-28 patch in the first place, just to make sure
we didn't go backwards. The current memory leak complaint is
unfortunately hard to test for in the regression test framework,
though manual testing shows it's fixed. Although this is a
pre-existing bug, I'm not back-patching because I'd like to see this
method get some field testing first. Consider back-patching if it
gets through 8.4beta unscathed.

- In pgsql/src/backend/utils/misc/guc-file.l, treat EOF like \n for
line-counting purposes in ParseConfigFile, per bug #4752. Fujii
Masao

- Remove SQL-compatibility function cardinality(). It is not exactly
clear how this ought to behave for multi-dimensional arrays. Per
discussion, not having it at all seems better than having it with
what might prove to be the wrong behavior. We can always add it
later when we have consensus on the correct behavior.

- In pgsql/doc/src/sgml/gin.sgml, update GIN limitations documentation
to match current reality.

- Update time zone data files to tzdata release 2009e: DST law changes
in Argentina/San_Luis, Cuba, Jordan (historical correction only),
Morocco, Palestine, Syria, Tunisia.

- In pgsql/doc/src/sgml/release.sgml, update release notes through
yesterday; some minor wordsmithing.

- Add cross-references from the DECLARE and FETCH reference pages to
the plpgsql documentation about cursors. Per a suggestion from
Matthew Wakeling.

- In pgsql/src/bin/pg_dump/pg_dumpall.c, fix pg_dumpall so that when
--clean is specified, it drops roles and tablespaces in an order
that has some chance of working. Per a complaint from Kevin Bailey.
This is a pre-existing bug, but given the lack of prior complaints
I'm not sure it's worth back-patching. In most cases failure of the
DROP commands wouldn't be that important anyway. In passing, fix
syntax errors in dumpCreateDB()'s queries for old servers; these
were apparently introduced in recent binary_upgrade patch.

Bruce Momjian committed:

- In pgsql/src/bin/psql/tab-complete.c, adjust psql tab completion for
new \d 'S' flag behavior; adjust code to be more flexible about
additional modifiers for \d commands.

- In pgsql/doc/src/sgml/maintenance.sgml, add documentation mention of
'check_postgres.pl' in Routine Database Maintenance Tasks section.

- In pgsql/doc/src/sgml/maintenance.sgml, doc change in new patch,
stand-alone -> standalone.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, display
postgresql.conf unit options in an easier-to-understand, 2-column
format.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, document in
postgresql.conf that the default units for log_min_duration_statement
is milliseconds.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, properly
align equals signs in new postgresql.conf units comments.

- Add unit documentation for various postgresql.conf settings.

- In pgsql/doc/src/sgml/trigger.sgml, add doc link to section about
how to compile triggers.

- Remove FAQ and FAQ_DEV ASCII and HTML files from CVS; now on the
wiki. Per-language files kept for transator usage.

- In pgsql/doc/src/sgml/release.sgml, add release note item: Add
Japanese message translations

- In pgsql/doc/src/sgml/release.sgml, add attribution for: Add
Japanese message translations (Japan PostgreSQL Users Group).

- More GUC units doc updates. Euler Taveira de Oliveira.

- Disable effective_io_concurrency on Solaris because posix_fadvise()
is no-op on that platform.

- In pgsql/src/backend/utils/misc/guc.c, revert addition of units to
GUC descriptions; doesn't affect postgresql.conf.

- In pgsql/src/bin/psql/tab-complete.c, improve tab completion for
\ef. Andrew (RhodiumToad) Gierth.

- In pgsql/doc/src/sgml/wal.sgml, improve documentation about how
checkpoint spreads I/O activity.

- In pgsql/src/tools/RELEASE_CHANGES, no more need to update FAQs.

- In pgsql/doc/src/sgml/monitoring.sgml, clarify documentation
references to pg_stat_get_blocks_fetched and pg_stat_get_blocks_hit,
per suggestion from Robert Haas.

- In pgsql/doc/src/sgml/monitoring.sgml, document how *_blks_read
statistics columns are computed.

- In pgsql/doc/src/sgml/release.sgml, clarify SSL _user_
authentication in release notes.

- In pgsql/doc/src/sgml/client-auth.sgml, wording improvement for SSL
user certificate authentication.

- In pgsql/doc/src/sgml/client-auth.sgml, wording improvement.

- In pgsql/doc/src/sgml/libpq.sgml, better document libpq sslverify
behavior as requiring root.crt.

- In pgsql/doc/src/sgml/libpq.sgml, more wording clarification of
sslverify setting.

Peter Eisentraut committed:

- In pgsql/src/backend/utils/mb/mbutils.c, add entry in the encoding
number to OS name table for KOI8-U.

- XMLATTRIBUTES() should send the attribute values through
map_sql_value_to_xml_value() instead of directly through the data
type output function. This is per SQL standard, and consistent with
XMLELEMENT().

- Translation updates for 8.4 beta.

- Update config.guess and config.sub

- In pgsql/src/tools/RELEASE_CHANGES, add URL for config.guess/sub
updates.

- In pgsql/src/bin/psql/help.c, message improvement.

- In pgsql/src/bin/psql/print.c, message fix (I guess this was a
cruise replace mistake.)

Magnus Hagander committed:

- In pgsql/src/tools/msvc/Mkvcbuild.pm, support Perl 5.10 and TCL 8.5
in MSVC builds. We should probably have a better way to do this
(meaning something not hardcoded) eventually, but this fixes the
problem for 8.4. Dave Page.

Marc Fournier committed:

- Commit and tag beta1.

Alvaro Herrera committed:

- In pgsql/src/bin/psql/common.c, make string more alike other similar
messages.

Andrew Dunstan committed:

- In pgsql/src/bin/pg_dump/pg_backup_archiver.c, fix logic to detect
conflicts or blocks involving exclusive locks in parallel restore
items. If a currently running item needs an exclusive lock on any
item that the candidate items needs any sort of lock on, or vice
versa, then the candidate item is not allowed to run now, and must
wait till later.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Pavel Stehule sent in another revision of his transformationHook
patch.

Pavel Stehule sent in a patch to add EEEE format support to to_char.

Taro Minowa(Higepon) sent in a patch to auto-delete large objects when
the referencing row is deleted.

Fujii Masao sent in another revision of his new trigger option for
standby patch.

Magnus Hagander sent in a patch to fix path separator issues on
Windows.

ITAGAKI Takahiro sent in an updated version of the sampling profiler
patch.

David Fetter sent in three patches to account for windowing functions
in psql.

Abhijit Menon-Sen sent in a patch to add tests for quoting and other
abuses in functions.

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