== Wöchentlicher PostgreSQL Newsletter - 14. März 2010 ==

Der Originalartikel befindet sich unter:

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

== Wöchentlicher PostgreSQL Newsletter - 14. März 2010 ==

Bugfix Releases für 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24 und 7.4.28
erscheinen bald. Fertigmachen zum Upgrade!

SFPUG wird ein weltweites Test-Fest für PostgreSQL 9 am 3. April 2010
leiten. Egal ob du in der San Francisco Bay Area bist oder nicht,
hier findest du Details:
http://it.toolbox.com/blogs/database-soup/april-3-postgresql-testfest-day-37458

PostgreSQLfr hat einen Stand auf der SolutionsLinux 2010 in Paris,
Frankreich vom 16. bis 18. März 2010. Helfer kontaktieren bitte
Stephane Schildknecht unter sas AT postgresql DOT fr, oder die
normale PostgreSQLfr Adresse unter bureau AT postgresql DOT fr.
Mehr Informationen über die Konferenz unter:
http://www.solutionslinux.fr

== PostgreSQL Produkt Neuigkeiten ==

Archiveopteryx 3.1.3, ein PostgreSQL-basierender
E-Mail Handler, ist erschienen.
http://www.archiveopteryx.org/3.1.3

pgAdmin 1.10.2, ein GUI-basierendes Management
Werkzeug für PostgreSQL, ist erschienen.
http://www.postgresql.org/ftp/pgadmin3/release/v1.10.2/

PostGIS 1.4.2 und 1.5.1 sind erschienen.
http://postgis.org/download

== PostgreSQL 9.0 Feature der Woche ==

in pl/pgSQL, MOVE funktioniert jetzt umfassend mit CURSOR.

== PostgreSQL Tipp der Woche ==

== PostgreSQL Jobs im März ==

http://archives.postgresql.org/pgsql-jobs/2010-03/threads.php

== PostgreSQL Lokal ==

Die Deutsche PostgreSQL User Gruppe hat einen Stand auf den Chemnitzer
Linuxtagen 2010 am 13. und 14. März 2010 in Chemnitz, Deutschland.
Andreas (ads) Scherbaum hält einen Vortrag über PostgreSQL 9.0 und
einen Workshop zum Thema "PostgreSQL tunen".
http://andreas.scherbaum.la/blog/archives/652-PostgreSQL-stand-at-Chemnitz-Linux-Days-2010.html
http://chemnitzer.linux-tage.de/2010/vortraege/plan.html

JDCon East wird vom 25. bis 28. März 2010 in Philadelphia, PA, USA
stattfinden.
http://www.postgresqlconference.org/2010/east

Die San Francisco PostgreSQL Uergruppe wird ein Testfest am Samstag dem
3. April von 11 Uhr bis 18 Uhr veranstalten. Es wird Live Videos geben.
Hilf mit, dies zu einem weltweiten Event zu machen!
http://wiki.postgresql.org/wiki/SFPUG_Beta_Test_Day

Linuxfest Nordwest 2010 findet in Bellingham, Washington, USA am
24. und 25. April statt. Vortragsreihen, Stände und Sponsoring
sind verfügbar.
http://linuxfestnorthwest.org/

Andreas (ads) Scherbaum hält einen Kurs "PostgreSQL im
Unternehmenseinsatz" an der VHS Magdeburg, Deutschland, vom 03. bis 07.
Mai 2010. Details unter:
http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19.
http://www.pgcon.org/2010/registration.php

Der CfP für OSBridge ist eröffnet! OSBridge findet vom 1. bis 4.
Juni 2010 in Portland, Oregon statt.
http://opensourcebridge.org/events/2010/proposals/

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.
http://www.oscon.com/oscon2010

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

Magnus Hagander committed:

- In pgsql/src/backend/libpq/hba.c, disallow gssapi authentication on
local connections, since it requires a hostname to function. Noted
by Zdenek Kotala.

- In pgsql/src/interfaces/libpq/fe-auth.c, require hostname to be set
when using GSSAPI authentication. Without it, the GSSAPI libraries
crash. Noted by Zdenek Kotala.

- In pgsql/doc/src/sgml/ref/psql-ref.sgml, add missing space in
example. Tim Landscheidt.

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/ecpglib/error.c, better test the
content of the SQLSTATE string in ecpglib than the pointer.

- In pgsql/src/interfaces/ecpg/ecpglib/error.c, backport fix from HEAD
that makes ecpglib give the right SQLSTATE if the connection
disappears.

- Ecpg now adds a unique counter to its varchar struct definitions to
make these definitions unique, too. It used to use the linenumber
but in the rare case of two definitions in one line this was not
unique.

Bruce Momjian committed:

- In pgsql/src/bin/psql/command.c, return proper exit code (3) from
psql when ON_ERROR_STOP=on and --single-transaction are both used
and the failure happens in commit, e.g. failed deferred trigger.
Also properly free BEGIN/COMMIT result structures from
--single-transaction. Per report from Dominic Bevacqua

- In pgsql/doc/src/sgml/config.sgml, remove unnecessary comma in
documentation.

- In pgsql/doc/src/sgml/config.sgml, re-add comma, oops.

- In pgsql/src/timezone/zic.c, small adjustment by pgindent.

- In pgsql/src/backend/tsearch/wparser_def.c, allow underscores in
tsearch email addressses, per RFC 5322 and report by Dan O'Hara.
Patch by Teodor Sigaev

- In pgsql/doc/src/sgml/textsearch.sgml, document what user name email
symbols are supported by tsearch.

- Add libpq warning message if the .pgpass-retrieved password fails.
Add ERRCODE_INVALID_PASSWORD sqlstate error code.

- In pgsql/src/backend/libpq/pqcomm.c, move TCP keepalive macro
definition. Jaime Casanova

- In pgsql/src/backend/libpq/pqcomm.c, move more tcp keepalive macros
to be consistent.

- In pgsql/src/backend/libpq/pqcomm.c, revert all keepalive moves,
reevaluate.

Andrew Dunstan committed:

- In pgsql/src/pl/plperl/plperl.c, add checks for valid encoding of
query strings passed to SPI by plperl.

Alvaro Herrera committed:

- Update time zone data files to tzdata release 2010e: DST law changes
in Fiji, Samoa, Chile; corrections to recent changes in Paraguay and
Bangladesh.

- Improve PL/Perl documentation of database access functions.
(Backpatch to 8.4 of a patch previously applied by Bruce Momjian to
CVS HEAD) Alexey Klyukin.

Tom Lane committed:

- In pgsql/src/pl/plperl/plperl.c, use SvROK(sv) rather than directly
checking SvTYPE(sv) == SVt_RV in plperl. The latter is considered
unwarranted chumminess with the implementation, and can lead to
crashes with recent Perl versions. Report and fix by Tim Bunce.
Back-patch to all versions containing the questionable coding
pattern.

- Preliminary release notes for releases 8.4.3, 8.3.10, 8.2.16,
8.1.20, 8.0.24, 7.4.28.

- In pgsql/src/include/catalog/pg_constraint.h, update comment for
pg_constraint.conindid to mention that it's used for exclusion
constraints. Not sure how we managed to update the comment for it
in catalogs.sgml but miss this one.

- Simplify a couple of pg_dump and psql \d queries about index
constraints by joining to pg_constraint.conindid, instead of the
former technique of joining indirectly through pg_depend. This is
much more straightforward and probably faster as well. I had
originally desisted from changing these queries when conindid was
added because I was worried about losing performance, but if we join
on conrelid as well as conindid then the index on conrelid can be
used when pg_constraint is large.

- In pgsql/src/bin/psql/describe.c, modify psql's \d printout to fold
exclusion constraints in with regular indexes, rather than printing
them twice. Per my gripe when the exclusion constraint feature was
committed.

- In pgsql/src/backend/access/common/reloptions.c, add missing reset
of need_initialization in reloptions code. This resulted in useless
extra work during every call of parseRelOptions, but no bad effects
other than that. Noted by Alvaro Herrera.

- In pgsql/src/timezone/pgtz.c, fix a commented-out block of code that
pgindent didn't understand properly; it's been making that comment
uglier with each run.

- In pgsql/src/backend/postmaster/pgstat.c, add some logging code for
unexpected cases, particularly being unable to read a stats file for
reasons other than ENOENT, and having to reset last_statrequest
because it's later than current time in the collector. Not clear if
this will shed any light on the "pgstat wait timeout" business, but
it seems like a good idea in general. In passing, do some
message-style-police work on recently-added
pgstat_reset_shared_counters code.

- Update oidjoins regression test for 9.0.

ITAGAKI Takahiro committed:

- pg_start_backup() can use a share lock to lock ControlFileLock
instead of an exclusive lock. The change is almost for code
cleanup. Since there seems to be no performance benefits from it,
backports should not be needed. Fujii Masao

Robert Haas committed:

- In pgsql/src/backend/commands/tablecmds.c, fix incorrect comment
about permissions checking being done in utility.c. Noted while
reviewing a patch from KaiGai Kohei.

Heikki Linnakangas committed:

- In pgsql/src/backend/storage/ipc/standby.c, fix comment which was
apparently copy-pasted from another function.

- In pgsql/src/backend/storage/ipc/procarray.c, fix bug in
KnownAssignedXidsMany(). I saw this when looking at the assertion
failure reported by Erik Rijkers, but this alone doesn't explain the
failure.

Marc Fournier committed:

- Tag 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24, and 7.4.28.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/runtime.sgml, update shared memory
configuration information for Linux In particular, the assertion
that shmall is sufficiently sized by default is slowly becoming
untrue.

- In pgsql/doc/src/sgml/plpython.sgml, add some more structure and
bits of information to PL/Python documentation

== Abgelehnte Patches (bis jetzt) ==

Dag-Erling Smorgrav's patch to address build issues on Windows XP with
the MinGW toolkit. The actual fix will be to de-support
--disable-shared.

== Eingesandte Patches ==

Fujii Masao sent in a patch which adds a new function
pg_last_checkpoint_start_location() that reports the XLOG location
where the last checkpoint or restartpoint started, i.e. the REDO
starting location.

Pavel Stehule sent in two revisions of a patch for 9.1 which adds a
some string functions including format(), sprintf() and concat_*().

Fujii Masao sent in a patch which makes it possible to interrupt
walreceiver on win32.

KaiGai Kohei sent in another revision of the patch to disallow
renaming system-initialized objects such as the "columns" in
sequences.

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