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

[Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>]

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