== Wöchentlicher PostgreSQL Newsletter - 08. Februar 2009 ==

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

== Wöchentlicher PostgreSQL Newsletter - 08. Februar 2009 ==

PostgreSQL 8.3.6, 8.2.12, 8.1.16, 8.0.20 und 7.4.24 erschienen.
Jetzt upgraden!
http://www.postgresql.org/docs/current/static/release.html

Der 2. Call for Papers für die PostgreSQL Conference East endet am 23.
Februar 2009.
http://www.postgresqlconference.org/

Wenn du Mappen für die LAPUG Pizza Party am Freitag den 20. Februar im
Westin in Los Angeles üllen möchtest, schreibe an lapug AT postgresql
DOT org um zu helfen.

== PostgreSQL Produkt Neuigkeiten ==

pgpool-II 2.2 beta2 erschienen.
http://pgfoundry.org/projects/pgpool/

== PostgreSQL Tipp der Woche ==

Bis 8.4 mit einer sehr effizienten eingebauten array_accum() Funktion
herauskommt, kannst du selbige Funktion aus der PostgreSQL Dokumentation
addieren und damit alle Spalten in ein Array zusammenfügen. Dies kann in
Applikationen genutzt werden oder zusammen mit array_to_string() um eine
Liste zu erstellen:
http://www.postgresql.org/docs/current/static/xaggr.html

== PostgreSQL Jobs im Februar ==

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

== PostgreSQL Lokal ==

JNBPUG trifft sich am 9. Februar um 19:00 Uhr im News Cafe in der
New Road in Midrand.

Stephen Frost wird über Column-Level Permissions bei der BWPUG sprechen,
am 9. Februar um 18:30 Uhr in den OmniTI Büros.
http://pugs.postgresql.org/bwpug

Der Prager PostgreSQL Entwicklertag 2009 findet am 12. Februar statt.
http://www.postgresql.org/about/event.808
Zeitplan:
http://www.postgres.cz/p2d2/2009/sched_en.html

Die Bulgarische PostgreSQL User Gruppe trifft sich am 12. Februar 2009
um 19 Uhr im Vinarnata, 19 Lavele str., Sofia.
http://www.doodle.com/participation.html?pollId=vb788q7v8ybi4z39

SFPUG präsentiert: Reece Hart von Unison DB für rechenbetonte Biologie
am 10. Februar 2009, der Ort wird noch bekannt gegeben.
http://postgresql.meetup.com/1/calendar/9351228/

PostgreSQL wird auf der SCALE vom 20. bis 22. Februar in Los Angeles
vertreten sein.
http://www.socallinuxexpo.org/

Andreas 'ads' Scherbaum wird einen Vortrag auf dem Perl Workshop 2009
am 25. Februar in Frankfurt am Main, Deutschland, halten.
http://www.perl-workshop.de/talks/151/view

PostgreSQL Conference U.S. wird einen PgDay auf dem Linuxfest Nordwest
am 25. und 26. April veranstalten. Der Call for Papers ist unter:
http://www.postgresqlconference.org/

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.
http://www.pgcon.org/2009/papers.php

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.

== 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(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/catalogs.sgml, put pg_user_mapping section
into the right (alphabetical) order.

- In pgsql/src/backend/catalog/sql_features.txt, set column privileges
to supported.

Michael Meskes committed:

- Fixed bug in ecpg's %s handling.

- Fixed auto allocation for binary data types in ecpg.

- In pgsql/src/interfaces/ecpg/test/sql/binary.pgc, set memory segment
to '0', just to be sure.

- In ecpg, when changing a regression test file one should also change
the expected output file.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, fixed copy&paste
mistake that made library use uninitialized variable.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, argh, wrong line
copied again.

- In ecpg, added result checks for calls to gmtime().

- In pgsql/src/interfaces/ecpg/pgtypeslib/dt_common.c, mixing long and
int entries of a union only works on some architectures.

Alvaro Herrera committed:

- Allow reloption names to have qualifiers, initially supporting a
TOAST qualifier, and add support for this in pg_dump. This allows
TOAST tables to have user-defined fillfactor, and will also enable
us to move the autovacuum parameters to reloptions without taking
away the possibility of setting values for TOAST tables.

- Fix some SGML-compiler warnings on -wxml mode.

Andrew Dunstan committed:

- Provide for parallel restoration from a custom format archive. Each
data and post-data step is run in a separate worker child (a thread
on Windows, a child process elsewhere) up to the concurrent number
specified by the new pg_restore command-line --multi-thread | -m
switch. Andrew Dunstan, with some editing by Tom Lane.

- Allow alternative names for tclsh used on Windows.

Tom Lane committed:

- In pgsql/src/pl/plpgsql/src/gram.y, fix plpgsql to not treat INSERT
INTO as an INTO-variables clause anywhere in the string, not just at
the start. Per bug #4629 from Martin Blazek. Back-patch to 8.2;
prior versions don't have the problem, at least not in the reported
case, because they don't try to recognize INTO in non-SELECT
statements. (IOW, this is really fallout from the RETURNING patch.)

- In pgsql/doc/src/sgml/ref/select.sgml, document the longstanding
behavior of LIMIT NULL and OFFSET NULL, per gripe from David Wheeler
that this was mentioned nowhere. In passing, editorialize a bit on
the description of the SQL:2008 equivalent syntax.

- In pgsql/src/backend/postmaster/syslogger.c, add a failure check for
syslogger's use of _beginthreadex(), and remove unnecessary thread
address output parameter, to make this code look more like that in
pg_restore.

- In pgsql/src/backend/optimizer/path/joinpath.c, fix an old
corner-case error in match_unsorted_outer(): don't consider the
cheapest-total inner path as a new candidate while truncating the
sort key list, if it already matched the full sort key list. This
is too much of a corner case to be worth back-patching, since it's
unusual for the cheapest total path to be sorted, and anyway no real
harm is done (except in JOIN_SEMI/ANTI cases where cost_mergejoin is
a bit broken at the moment). But it wasn't behaving as intended, so
fix it. Noted while examining a test case from Kevin Grittner.
This error doesn't explain his issue, but it does explain why "set
enable_seqscan = off" seemed to reproduce it for me.

- Clean up some loose ends from the column privileges patch: add
has_column_privilege and has_any_column_privilege SQL functions; fix
the information_schema views that are supposed to pay attention to
column privileges; adjust pg_stats to show stats for any column you
have select privilege on; and fix COPY to allow copying a subset of
columns if the user has suitable per-column privileges for all the
columns. To improve efficiency of some of the information_schema
views, extend the has_xxx_privilege functions to allow inquiring
about the OR of a set of privileges in just one call. This is just
exposing capability that already existed in the underlying aclcheck
routines. In passing, make the information_schema views report the
owner's own privileges as being grantable, since Postgres assumes
this even when the grant option bit is not set in the ACL. This is
a longstanding oversight. Also, make the new has_xxx_privilege
functions for foreign data objects follow the same coding
conventions used by the older ones. Stephen Frost and Tom Lane

- In pgsql/doc/src/sgml/ref/copy.sgml, ooops, forgot to update COPY
reference page to mention column privileges.

- Fix cost_mergejoin's failure to adjust for rescanning of non-unique
merge join keys when considering a semi or anti join. This requires
estimating the selectivity of the merge qual as though it were a
regular inner join condition. To allow caching both that and the
real outer-join-aware selectivity, split RestrictInfo.this_selec
into two fields. This fixes one of the problems reported by Kevin
Grittner.

- In pgsql/src/backend/executor/execMain.c, ensure that INSERT ...
SELECT into a table with OIDs never copies row OIDs from the source
table. This could never happen anyway before 8.4 because the
executor invariably applied a "junk filter" to rows due to be
inserted; but now that we skip doing that when it's not necessary,
the case can occur. Problem noted 2008-11-27 by KaiGai Kohei,
though I misunderstood what he was on about at the time (the opacity
of the patch he proposed didn't help).

Bruce Momjian committed:

- In pgsql/doc/src/sgml/mvcc.sgml, update read committed documentation
to better explain undesirable behavior of concurrent commands in
cases where rows are being added and removed from matching query
criteria. Minor word-smithing.

- Add PL/PgSQL FOUND and GET DIAGNOSTICS support for RETURN QUERY
statement. Pavel Stehule.

- In pgsql/doc/src/sgml/libpq.sgml, document ways to avoid libpq
WSACleanup() overhead on Windows. Andrew Chernow.

- In pgsql/doc/src/sgml/libpq.sgml, fix typo in docs.

- Fix to_timestamp() to not require upper/lower case matching for
meridian designations (AM/PM). Also separate out matching of a
meridian with periods (e.g. A.M.) and with those without. Do the
same for AD/BC. Brendan Jurd

- Document disabling the statistics collector pg_dump activity, and
give a bit more visibility to the PGOPTIONS environment variable
supported by libpq. Bryce Nesbitt

- In pgsql/doc/src/sgml/catalogs.sgml, update pg_constraint.conkey
documentation description.

- In pgsql/doc/src/sgml/ref/pg_dump.sgml, properly wrap new pg_dump
doc text.

- In pgsql/src/interfaces/ecpg/ecpglib/Makefile, ecpg requires libpq;
add Makefile rules to require libpq to be built first. Alvaro
Herrera.

- In pgsql/doc/src/sgml/catalogs.sgml, uppercase CHECK mention in
relchecks documentation mention.

- In pgsql/doc/src/sgml/indices.sgml, remove documentation mention
that hash indexes perform no better than btree; keep mention about
missing WAL logging. Kenneth Marshall

- In pgsql/doc/src/sgml/queries.sgml, document that LIMIT NULL is the
same as no LIMIT clause. Report by David Wheeler.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/xlog.c, fix obsolete comment.
Zdenek Kotala.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Fernando Ike de Oliveira sent in another revision of his patch to add
\dL (show languages) to psql.

David Wheeler sent in a doc patch to explicate that LIMIT NULL returns
all rows.

Zdenek Kotala sent in a fix for Czech (cs_CZ) locale regression tests.

Stephen Frost sent in another revision of his column-level privileges
patch.

Teodor Sigaev sent in another revision of his GIN improvements patch.

KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.

Alvaro Herrera sent in another revision of the reloptions patch to
remove autovacuum parameters.

Peter Eisentraut sent in a patch to add basic KOI8-U support.

Alvaro Herrera sent in a doc patch for the reloptions patch.

David Lee Lambert sent in a patch which lets Linux use the ext2fs UUID
generator for UUIDs.

Tom Lane sent in a patch to make ALTER TABLE SET WITH OIDS actually
add the aforementioned OIDs.

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