== Wöchentlicher PostgreSQL Newsletter - 25. Mai 2008 ==

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/index.php?/archives/174-PostgreSQL-Weekly-News-May-25-2008.html

== Wöchentlicher PostgreSQL Newsletter - 25. Mai 2008 ==

Das Mai Commitfest ist abgeschlossen. Die verbleibenden Patches in der
Warteschlange sind Heikkis Patch für Map-Forks, der sich noch in
Bearbeitung befindet und daher nicht zum Committen gedacht war sowie
Merlin und Andrews libpq Hooks Patch, welcher derzeit noch verändert
wird und somit nicht fertig zum committen ist.

PgCon 2008 war ein voller Erfolg! Die Leute haben Dinge auf dem
Developer Meeting ausdiskutiert, zusammen mit einem geheimen Cabal
Meeting.
Teilnehmer sind von weit her angereist, am weitesten Pune, Indien.

== PostgreSQL Produkt Neuigkeiten ==

DbWrench Database Design v1.4.7 erschienen.
http://www.dbwrench.com/

MicroOLAP Database Designer für PostgreSQL ver.1.2.4-beta erschienen.
http://microolap.com/products/database/postgresql-designer/download/

Npgsql 2 Beta4 erschienen.
http://pgfoundry.org/projects/npgsql/

Der Call for Papers für "OSS 2.0: Leveraging the Open Source Community
for Business" ist eröffnet. Beiträge müssen bis zum 21. Juni 2008
eingereicht werden.
http://conferenze.dei.polimi.it/oss20

pgtcl 1.7 erschienen.
http://pgfoundry.org/projects/pgtcl/

Playr 0.1 erschienen.
https://area51.myyearbook.com/trac.cgi/wiki/Playr

== PostgreSQL Jobs im Mai ==

http://archives.postgresql.org/pgsql-jobs/2008-05/threads.php

== PostgreSQL Lokal ==

Die griechische PUG wird einen Stand auf der dritten Griechischen FLOSS
Konferenz vom 27.-29. Mai in Athen, NTUA, haben.
http://www.postgresql.gr

LAPUG trifft sich am 30. Mai 2008 im Cal Poly.
Non-trivial updateable views, von Keith Larson.
http://pugs.postgresql.org/node/390

Der Call for Papers für PgCon.BR ist eröffnet. Der Einsendeschluss ist
am 31. Mai, also die Vorträge jetzt einreichen.
http://pgcon.postgresql.org.br/chamadas.en.html

PGDay wird in Portland am Tag vor der OSCON stattfinden.
http://pugs.postgresql.org/taxonomy/term/53

Der Call for Papers für die Utah Open Source Konferenz 2008 ist bis zum
1. Juni offen. Diese 2. jährliche Konferenz wird vom 28. bis 30. August
2008 in Salt Lake City, UT stattfinden.
http://2008.utosc.com/

PGCon Brazil 2008 wird vom 26.-27. September auf dem Unicamp in
Campinas stattfinden.
http://pgcon.postgresql.org.br/index.en.html

PGDay.IT 2008 wird am 17. und 18. Oktober in Prato stattfinden.
http://www.pgday.org/it/

== PostgreSQL in den News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Tom Lane.

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:

- Coercion sanity check in ri_HashCompareOp failed to allow for enums,
as per example from Rod Taylor. On reflection the correct test here
is for any polymorphic type, not specifically ANYARRAY as in the
original coding.

- Make to_char()'s localized month/day names depend on LC_TIME, not
LC_MESSAGES. Euler Taveira de Oliveira

- Adjust -Wl,--asneeded test to avoid using the switch if it breaks
libreadline. What we will do for compatibility :-(

- Adjust timestamp regression tests to prevent two low-probability
failure cases. Recent buildfarm experience shows that it is
sometimes possible to execute several SQL commands in less time than
the granularity of Windows' not-very-high-resolution gettimeofday(),
leading to a failure because the tests expect the value of now() to
change and it doesn't. Also, it was recognized some time ago that
the same area of the tests could fail if local midnight passes
between the insertion and the checking of the values for
'yesterday', 'tomorrow', etc. Clean all this up per ideas from
myself and Greg Stark. There remains a window for failure if the
transaction block is entered exactly at local midnight (so that
'now' and 'today' have the same value), but that seems
low-probability enough to live with. Since the point of this change
is mostly to eliminate buildfarm noise, back-patch to all versions
we are still actively testing.

Heikki Linnakangas committed:

- Remove arbitrary 10MB limit on two-phase state file size. It's not
that hard to go beoynd 10MB, as demonstrated by Gavin Sharry's
example of dropping a schema with ~25000 objects. The really bogus
thing about the limit was that it was enforced when a state file
file was read in, not when it was written, so you would end up with
a prepared transaction that you can't commit or abort, and the only
recourse was to shut down the server and remove the file by hand.
Raise the limit to MaxAllocSize, and enforce it also when a state
file is written. We could've removed the limit altogether, but
reading in a file larger than MaxAllocSize would fail anyway because
we read it into a palloc'd buffer. Backpatch down to 8.1, where 2PC
and this issue was introduced.

Bruce Momjian committed:

- Mark TODO as done: "Use LC_TIME for localized weekday/month names."

- In pgsql/src/backend/utils/adt/formatting.c, simplify code now that
to_(upper|lower|initcap) do not modify the passed string.

Michael Meskes committed:

- Synced parser. Made ecpg parser use backend provided keyword list.
Changed whenever test so exit value is 0.

- In pgsql/src/interfaces/ecpg/preproc/Makefile, ecpg_keywords.o also
depends on preproc.h

- Link in keywords file instead of copying it. Use #define/#ifdef
instead of sed to fix include files, this should work on Windows
too.

Magnus Hagander committed:

- Use CRITICAL_SECTION instead of Mutexes for thread-locking in libpq
on Windows, for better performance. Per suggestion from Andrew
Chernow, but not his patch since the underlying code was changed to
deal with return values.

- In pgsql/src/bin/psql/print.c, fix function headers not matching
prototype in header file, per compiler warnings on msvc.

- In pgsql/src/tools/msvc/Mkvcbuild.pm, add include directory required
after the latest changes to the ecpg build. Per red Windows
buildfarm members.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Guillaume Lelarge sent in a patch to make psql backward-compatible to
7.4. Bryce Nesbitt followed up with one of his own.

Andrew Chernow sent in another revision of the libpq object hooks
patch.

Greg Sabino Mullane sent in a documentation patch by Kevin L. McBride
explaining LOCK_DEBUG options in detail.

Gregory Stark sent in three revisions of a patch which makes \d+ show
storage options for columns, per discussion with Oleg Bartunov.

Jaime Casanova sent in two versions of a patch to extent GRANT's scope
on sequences.

Heikki Linnakangas sent in another revision of his FSM rewrite patch.

Dickson Guedes sent in a patch in collaboration with Euler Taveira de
Oliveira which makes \d and \d+ on sequences produce more useful
output.

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