== Wöchentlicher PostgreSQL Newsletter - 11. Oktober 2009 ==

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

== Wöchentlicher PostgreSQL Newsletter - 11. Oktober 2009 ==

Das aktuelle Commitfest endet diese Woche, danach kommt recht bald
Alpha2. Fertigmachen zum Testen!

Josh Berkus präsentiert: die mächtigen GUCS der SFPUG in San Francisco
am 13. Oktober um 19 Uhr Pazifischer Zeit. Details zum Webcast ect
unter:
http://postgresql.meetup.com/1/calendar/11052731/

Federico Campoli wird einen PostgreSQL Vortrag auf der GULP (Linuxtag
Pisa) am 24. Oktober 2009 halten. Informationen auf italienisch unter:
http://linuxday2009.gulp.linux.it/

== PostgreSQL Produkt Neuigkeiten ==

PGLogAnalysis 0.5, ein Log Analysierer für PostgreSQL, ist erschienen.
http://code.google.com/p/pgloganalysis/

Oleg Bartunov hat ein neues Contrib Modul für PostgreSQL erstellt:
Plantuner.
http://www.sai.msu.su/~megera/wiki/plantuner

PostgreDAC ver. 2.5.3, ein Delphi/C++ Builder für PostgreSQL, ist
erschienen.
http://microolap.com/products/connectivity/postgresdac/download/

Prefix 1.0.0, ein Modul für schnelle Prefix Suchen, ist erschienen.
http://pgfoundry.org/projects/prefix/

Mark Kirkwood hat einen großen Performance Bug in PDO_pgsql, ein PHP
Modul um PostgreSQL Datenbanken anzusprechen, gefixt.
http://bugs.php.net/bug.php?id=48764

== PostgreSQL Jobs im Oktober ==

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

== PostgreSQL Lokal ==

Es findet eine Konferenz in Seattle, Washington, USA am 16.-18.
Oktober 2009 statt.
http://www.postgresqlconference.org/2009/west

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden. Registrierung offen:
http://pgcon.postgresql.org.br/2009/

Federico Campoli wird einen PostgreSQL Vortrag auf der GULP (Linuxtag
Pisa) am 24. Oktober 2009 halten. Informationen auf italienisch unter:
http://linuxday2009.gulp.linux.it/

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

OpenSQL Camp in Portland sucht Sponsoren. Bereite deine Reisepläne
jetzt vor! :)
http://www.chesnok.com/daily/2009/07/29/opensql-camp-comes-to-portland-november-14-15-2009/

Die 10. jährliche JPUG Konferenz findet am 20-21. November 2009 in
Tokio, Japan, statt.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

FOSDEM 2010 wird am 6./7. Februar 2010 in Brüssel stattfinden.
http://www.fosdem.org/

Die Chemnitzer Linuxtage finden am 13. und 14. März 2010 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.

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

Tom Lane committed:

- Create an ALTER DEFAULT PRIVILEGES command, which allows users to
adjust the privileges that will be applied to subsequently-created
objects. Such adjustments are always per owning role, and can be
restricted to objects created in particular schemas too. A notable
benefit is that users can override the traditional default privilege
settings, eg, the PUBLIC EXECUTE privilege traditionally granted by
default for functions. Petr (PJMODOS) Jelinek.

- Change CREATE TABLE so that column default expressions coming from
different inheritance parent tables are compared using equal(),
instead of doing strcmp() on the nodeToString representation. The
old implementation was always a tad cheesy, and it finally fails
completely as of 8.4, now that the node tree might contain syntax
location information. equal() knows it's supposed to ignore those
fields, but strcmp() hardly can. Per recent report from Scott Ribe.

- Support use of function argument names to identify which actual
arguments match which function parameters. The syntax uses AS, for
example funcname(value AS arg1, anothervalue AS arg2). Pavel
Stehule.

- Update plhandler.sgml to describe validators and inline handlers for
procedural languages.

- Remove very ancient tuple-counting infrastructure (IncrRetrieved()
and friends). This code has all been ifdef'd out for many years,
and doesn't seem to have any prospect of becoming any more useful in
the future. EXPLAIN ANALYZE is what people use in practice, and I
think if we did want process-wide counters we'd be more likely to
put in dtrace events for that than try to resurrect this code. Get
rid of it so as to have one less detail to worry about while
refactoring execMain.c.

- Split the processing of INSERT/UPDATE/DELETE operations out of
execMain.c. They are now handled by a new plan node type called
ModifyTable, which is placed at the top of the plan tree. In itself
this change doesn't do much, except perhaps make the handling of
RETURNING lists and inherited UPDATEs a tad less klugy. But it is
necessary preparation for the intended extension of allowing
RETURNING queries inside WITH. Marko (johto) Tiikkaja.

- Improve similar_escape() in two different ways: 1. Stop escaping ?
and {. As of SQL:2008, SIMILAR TO is defined to have
POSIX-compatible interpretation of ? as well as {m,n} and related
constructs, so we should allow these things through to our regex
engine. 2. Escape ^ and $. It appears that our regex engine will
treat ^^ at the beginning of the string the same as ^, and similarly
for $$ at the end of the string, which meant that SIMILAR TO was
effectively ignoring ^ at the start of the pattern and $ at the end.
Since these are not supposed to be metacharacters, this is a bug.
The second part of this is arguably a back-patchable bug fix, but
I'm hesitant to do that because it might break applications that are
expecting something like "col SIMILAR TO '^foo$'" to work like a
POSIX pattern. Seems safer to only change it at a major version
boundary. Per discussion of an example from Doug Gorley.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/Makefile, unbreak doc/src/sgml
maintainer-clean rule on VPATH builds.

- In pgsql/doc/src/sgml/Makefile, really unbreak maintainer-clean.
(Or rather, unbreak what the previous commit broke)

- Fix snapshot management, take two. Partially revert the previous
patch I installed and replace it with a more general fix: any time a
snapshot is pushed as Active, we need to ensure that it will not be
modified in the future. This means that if the same snapshot is
used as CurrentSnapshot, it needs to be copied separately. This
affects serializable transactions only, because CurrentSnapshot has
already been copied by RegisterSnapshot and so PushActiveSnapshot
does not think it needs another copy. However,
CommandCounterIncrement would modify CurrentSnapshot, whereas
ActiveSnapshots must not have their command counters incremented. I
say "partially" because the regression test I added for the previous
bug has been kept. (This restores 8.3 behavior, because before
snapmgr.c existed, any snapshot set as Active was copied.) Per bug
report from Stuart Bishop.

- Make it possibly to specify GUC params per user and per database.
Create a new catalog pg_db_role_setting where they are now stored,
and better encapsulate the code that deals with settings into its
realm. The old datconfig and rolconfig columns are removed. psql
has gained a \drds command to display the settings. Backwards
compatibility warning: while the backwards-compatible system views
still have the config columns, they no longer completely represent
the configuration for a user or database. Catalog version bumped.

- Add the new psql command \drds to the psql docs, help and tab
completion. I also thank Bernd Helmle for the documentation help on
the previous settings patch, which I forgot on the commit message.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/Makefile, clean up the clean rules of the
documentation. Most things should be cleaned by "make clean",
except the parts that are shipped in the tarball. These rules had
gotten a bit out of whack after the various restructurings of the
documentation build rules.

- Use pg_get_triggerdef in pg_dump. Add a variant of
pg_get_triggerdef with a second argument "pretty" that causes the
output to be formatted in the way pg_dump used to do. Use this
variant in pg_dump with server versions >= 8.5. This insulates
pg_dump from most future trigger feature additions, such as the
upcoming column triggers patch. Itagaki Takahiro.

Heikki Linnakangas committed:

- Fix off-by-one bug in bitncmp(): When comparing a number of bits
divisible by 8, bitncmp() may dereference a pointer one byte out of
bounds. Chris Mikkelson (bug 5101).

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

ITAGAKI Takahiro sent in another revision of the buffer usage patch
for EXPLAIN and pg_stat_statements.

Zoltan Boszormenyi sent in another revision of the SQLDA patch for
ECPG.

Martin Pihlak sent in a patch to fix a regression test breakage in
foreign data wrappers when a system user exists with the same name.

Andrew (RhodiumToad) Gierth sent in a WIP patch to add ORDER BY to
array_agg() per SQL:2008.

Emmanuel Cecchet sent in another revision of the COPY enhancement
patch.

Roger Leigh sent in four more revisions of the patch to do Unicode
pretty-printing in psql.

KaiGai Kohei sent in two more revisions of the patch for large object
access controls.

Andreas 'ads' Scherbaum sent in another revision of the patch to add
CREATE OR REPLACE LANGUAGE.

Simon Riggs sent in another revision of the Hot Standby patch.

ITAGAKI Takahiro sent in another revision of the patch to fix the
console and eventlog issues on Win32.

Simon Riggs sent in a patch to add more "if (InHotStandby)" tests to
Hot Standby.

Simon Riggs sent in a patch to fix a subtransaction issue in Hot
Standby.

Zoltan Boszormenyi sent in two more revisions of the SQLDA patch for
ECPG along with a doc patch intended to go with.

Laurenz Albe sent in patches to add a hook which allows checking
cryptographic strength of passwords, a module which uses the hook and
documentation for the module.

Petr (PJMODOS) Jelinek sent in another revsion of the GRANT ON ALL IN
SCHEMA patch.

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