== WöchentlicherPostgreSQL Newsletter - 06.Dezember 2009

Der Originalartikel befindet sich unter:

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



== Wöchentlicher PostgreSQL Newsletter - 06. Dezember 2009 ==

Das aktuelle Commitfest endet bald. Reviewe jetzt die Patches der
anderen, damit du frisch an deinen eigenen Starten kannst :)

PostgreSQL hat jetzt offizielle Release-Regeln. Details unter:
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_P olicy

Neue Umfrage: Wie trägst du zu PostgreSQL bei?
http://www.postgresql.org/community

Jeff Davis präsentiert Operator Exclusion Constraints auf der SFPUG am
Dienstag, dem 8. Dezember in San Francisco.
http://postgresql.meetup.com/1/calendar/11928447/

Das nächste AustinPUG Treffen findet am Mittwoch, dem 9. Dezember 2009
statt. Jim Nasby wird über Tabellenvererbung sprechen.
http://pugs.postgresql.org/node/1500

Das erste Treffen der New York Capital District PUGs findet am 7.
Januar 2010 statt.
http://nycdpug.x10hosting.com/

PGDay-Kuba 2010 wird vom 4.-6. Februar 2010 in La Havana an der
Universität für wissenschaftliche Informatik stattfinden. Teilneh=
mer
von Kuba, der Dominikanischen Republik und Venezuela sind eingeladen.

== PostgreSQL Produkt Neuigkeiten ==

COBOL-IT Precompiler für PostgreSQL ist erschienen.
http://www.cobol-it.com/index.php?mact=3DNews,cntnt01,detail ,0&cntnt01artic=
leid=3D31&cntnt01detailtemplate=3Dsimple&cntnt01returnid=3D5 8

GT portalBase 2.4, ein Framework für PostgreSQL, ist erschienen.
http://www.gtportalbase.com/

PostgreSQL Maestro 9.12, ein GUI zum Administrieren und für die
Entwicklung unter Windows, ist erschienen.
http://www.sqlmaestro.com/products/postgresql/maestro/

MicroOLAP Database Designer 1.2.9 für PostgreSQL ist erschienen.
http://microolap.com/products/database/postgresql-designer/

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19. Der Call for Papers ist offen!
http://www.pgcon.org/2010/papers.php

pgpool-II 2.2.6, ein Connection Pooler und mehr,
ist erschienen.
http://pgfoundry.org/projects/pgpool/

PostgreDAC 2.5.4 beta, ein Delphi/C++ Builder für PostgreSQL, ist
erschienen.
http://microolap.com/products/connectivity/postgresdac/downl oad/

Quick Application Suite und Quick Application Builder sind erschienen.
http://www.datawarestudio.com/

== PostgreSQL Jobs im Dezember ==

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

== PostgreSQL Lokal ==

Stefan Keller gibt einen Kurs "Einführung in PostGIS/PostgreSQL" an
der HSR Hochschule für Technik Rapperswil (HSR) am 14. Januar 2010
in Zürich, Schweiz.
http://www.gis.hsr.ch/wiki/Agenda

FOSDEM 2010 findet am 6. und 7. Februar 2010 in Brüssel,
Belgien statt.
http://www.fosdem.org/

Die Chemnitzer Linuxtage finden am 13. und 14. März in
Chemnitz, Deutschland statt.
http://chemnitzer.linux-tage.de/

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

== Reviews ==

- Josh Tolley reviewed the PL/Python array support patch and sent a
patch atop it to fix regression tests.

- Jeff Davis reviewed Joachim Wieland's Listen/Notify patch and
requested further rework from the author.

- Andrew (RhodiumToad) Gierth reviewed Hitoshi Harada's patch to
improve window frame control with ROWS BETWEEN. To complete the
review, he will need a decision on the API for aggregate functions.

- Hitoshi Harada marked Andrew (RhodiumToad) Gierth's patch, "ready
for committer."

- Simon Riggs did a preliminary review of ITAGAKI Takahiro's
partitioning syntax patch.

- ITAGAKI Takahiro reviewed Greg Smith's patch to enable resetting
statistics.

== Applied Patches ==

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ecpg.sgml, properly indent SGML.

- There is no reference to THREAD_SUPPORT outside configure, and it is
never set, so remove it.

- In pgsql/doc/src/sgml/hstore.sgml, update hstore docs, mostly
word-smithing. David E. Wheeler

- Add ProcessUtility_hook() to handle all DDL to
contrib/pg_stat_statements. Itagaki Takahiro.

- Revert due to Tom's concerns: Add ProcessUtility_hook() to handle
all DDL to contrib/pg_stat_statements.

- Adjust 'psql -f -' to behave like a normal file and honor the -1
flag. Report from Robert Haas.

- Enable thread safety on all platforms. This will either be followed
up by a more extensive patch, or reverted, depending on the build
farm results.

- Apply full patch to enable thread-safety by default, e.g. doc
changes.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/xfunc.sgml, in SRF example, move oldcontext
variable definition into the FIRSTCALL branch, which is how most
actual code is actually structured. Also fix slight whitespace
misalignment.

- In pgsql/doc/src/sgml/information_schema.sgml, add a sentence of
documentation about the differences between the *_privileges and the
role_*_grants views.

- Speed up information schema privilege views. Instead of expensive
cross joins to resolve the ACL, add table-returning function
aclexplode() that expands the ACL into a useful form, and join
against that. Also, implement the role_*_grants views as a thin
layer over the respective *_privileges views instead of essentially
repeating the same code twice. Fixes bug #4596. By Joachim
Wieland, with cleanup by me.

Tom Lane committed:

- In pgsql/src/backend/tsearch/dict_thesaurus.c, avoid core dump on
empty thesaurus dictionary. Per report from Robert Gravsjo.

- Teach the regular expression functions to do case-insensitive
matching and locale-dependent character classification properly when
the database encoding is UTF8. The previous coding worked okay in
single-byte encodings, or in any case for ASCII characters, but
failed entirely on multibyte characters. The fix assumes that the
functions use Unicode code points as the wchar
representation for Unicode, ie, wchar matches pg_wchar. This is
only a partial solution, since we're still stupid about non-ASCII
characters in multibyte encodings other than UTF8. The practical
effect of that is limited, however, since those cases are generally
Far Eastern glyphs for which concepts like case-folding don't apply
anyway. Certainly all or nearly all of the field reports of
problems have been about UTF8. A more general solution would
require switching to the platform's wchar representation for all
regex operations; which is possible but would have substantial
disadvantages. Let's try this and see if it's sufficient in
practice.

- Instead of sending application_name as a SET command after the
connection is made, include it in the startup-packet options. This
makes it work more like every other libpq connection option, in
particular it now has the same response to RESET ALL as the rest.
This also saves one network round trip for new applications using
application_name. The cost is that if the server is pre-8.5, it'll
reject the startup packet altogether, forcing us to retry the entire
connection cycle. But on balance we shouldn't be optimizing that
case in preference to the behavior with a new server, especially
when doing so creates visible behavioral oddities. Per discussion.

- Mark application_name as GUC_REPORT so that the value will be
reported back to the client by the server. This might seem pretty
pointless but apparently it will help pgbouncer, and perhaps other
connection poolers. Anyway it's practically free to do so for the
normal use-case where appname is only set in the startup packet ---
we're just adding a few more bytes to the initial ParameterStatus
response packet. Per comments from Marko Kreen.

- In pgsql/src/backend/postmaster/postmaster.c, ignore attempts to set
"application_name" in the connection startup packet. This avoids a
useless connection retry and complaint in the postmaster log when
receiving a connection from 8.5 or later libpq. Backpatch in all
supported branches, but of course *not* HEAD.

- In pgsql/doc/src/sgml/ref/rollback_to.sgml, clarify what's supposed
to happen when a cursor FETCH is rolled back by aborting a
subtransaction. Per discussion with Heikki.

- In pgsql/src/include/catalog/pg_proc.h, don't use a duplicate OID
for aclexplode().

Teodor Sigaev committed:

- in contrib/btree_gist, prevent intersection of ranges during page
split. Changes are only optimization, so don't backpatch.

Heikki Linnakangas committed:

- Fix bug in temporary file management with subtransactions. A cursor
opened in a subtransaction stays open even if the subtransaction is
aborted, so any temporary files related to it must stay alive as
well. With the patch, we use ResourceOwners to track open temporary
files and don't automatically close them at subtransaction end
(though in the normal case temporary files are registered with the
subtransaction resource owner and will therefore be closed). At end
of top transaction, we still check that there's no temporary files
marked as close-at-end-of-transaction open, but that's now just a
debugging cross-check as the resource owner cleanup should've closed
them already.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

ITAGAKI Takahiro sent in another revision of the YAML output patch for
EXPLAIN.

ITAGAKI Takahiro sent in another revision of the VACUUM FULL patch per
review from Jeff Davis. Jeff Davis sent three patches atop that one.

Andrew (RhodiumToad) Gierth sent in another revision of the patch to
add ORDER BY to aggregates.

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

ITAGAKI Takahiro sent in a patch to modify the result type of
pg_read_file to bytea.

Bruce Momjian sent in two revisions of a patch to enable thread safety
in client libraries by default.

Zdenek Kotala sent in another revision of a patch to correct the
Docbook path in Solaris.

Tsutomu Yamada sent in two revisions of a patch to support Windows 64.

Caleb Welton sent in two revisions of a patch to fix int2vectorin.

Jeff Davis sent in another revision of the operator exclusion
constraints patch per review from Robert Haas.

Michael Paquier sent in two more revisions of the patch to add shell
calls to pgbench, per review from Greg Smith.

ITAGAKI Takahiro sent in another revision of the ProcessUtility_hook
patch per feedback from Tom Lane.

Bruce Momjian sent in a patch to install PL/pgsql by default.

Tim Bunce sent in a patch to refactor PL/Perl, and a patch atop that
to add some new GUCs with promising names including
plperl.on_perl_init, plperl.on_trusted_init, and
plperl.on_untrusted_init, along with some bug fixes and general code
correctness improvements.

KaiGai Kohei sent in another revision of the ACL patch for large
objects.

ITAGAKI Takahiro sent in another revision of the SQL syntax patch for
partitioning.

Zdenek Kotala sent in another revision of the patch to enable pg_ctl
to do an initdb.

Hitoshi Harada sent in another revision of the ROWS functionality for
windowing per review from Andrew (RhodiumToad) Gierth.

Jeff Davis sent in another revision of the VACUUM FULL removal patch.

Greg Smith sent in a patch to enable resetting statistics.

Simon Riggs sent in a patch to fix an issue with running out of lock
space in certain hot standby scenarios.

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