== Wöchentlicher PostgreSQL Newsletter - 06. Februar 2011 ==

== Wöchentlicher PostgreSQL Newsletter - 06. Februar 2011 ==

am 08.02.2011 00:38:45 von adsmail

Der Originalartikel befindet sich unter:


== Wöchentlicher PostgreSQL Newsletter - 06. Februar 2011 ==

Interview mit Simon Riggs bei O'Reilly GMT
http://www.oreillygmt.eu/open-sourcefree-software/all-about- postgresql-%E2%=
80%93-the-world%E2%80%99s-most-advanced-open-source-database /

== PostgreSQL Produkt Neuigkeiten ==

PGSI 1.6.0, ein Werkzeug das den Gesamteinfluß von PostgreSQL Anfragen
auf einem Server misst, ist erschienen:

== PostgreSQL Jobs im Februar ==

http://archives.postgresql.org/pgsql-jobs/2011-02/threads.ph p

== PostgreSQL Lokal ==

Selena Deckelmann wird über die Entwicklung der PostgreSQL
Community am 7. Februar 2010 um 16 Uhr an der Oregon State
University in Corvallis, OR sprechen.

Der vierte jährliche Prager PostgreSQL Development Day findet
am 10. Februar 2011 an der Charles Universität in Prag statt.

NYPUG trifft sich am 15. Februar 2011 um 18:15 Uhr im Yodle Office,
50 W 23rd St, New York, NY. Menr Informationen und Anmeldung unter:

PGDay findet dieses Jahr während der südkalifornischen Linux Auss=
(SCALE) im LAX Hilton Hotel in Los Angeles, Kalifornien am Freitag dem
25. Februar 2011 statt. Vorträge kannst du unter pgday-submissions AT
googlegroups DOT com einreichen.

PostgreSQL Conference East 2011: New York,
vom 22. bis 25. März

Das Open Database Camp findet vom 7. bis 9. Mai 2011 in Sardinien,
Italien statt.
http://datacharmer.blogspot.com/2011/01/announcing-open-data base-camp-sardi=

PGCon findet am 19. und 20. Mai 2011 an der Universität
von Ottawa statt, vorher gibt es am 17. und 18. Mai
zwei Tage mit Trainings. Der Call for Papers ist offen.

== PostgreSQL in den News ==

Planet PostgreSQL: http://planet.postgresql.org/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fet=

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org, spanische an pwn@arpug.com.ar.

== Reviews ==

== Angewandte Patches ==

Heikki Linnakangas pushed:

- Support multiple concurrent pg_basebackup backups. With this patch,
pg_basebackup doesn't write a backup_label file in the data
directory, so it doesn't interfere with a pg_start/stop_backup()
based backup anymore. backup_label is still included in the backup,
but it is injected directly into the tar stream. Heikki
Linnakangas, reviewed by Fujii Masao and Magnus Hagander.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D997b=

- Fix typo.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D3286=

- Remove spurious word, spotted by Thom Brown.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D44df=

Bruce Momjian pushed:

- Move upgrade instructions into its own section under "Server Setup
and Operation", merged from upgrade sections in "Installation from
Source Code" and "Backup and Restore". This now gives a single
place for all upgrade information.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc5ba=

- Fix SGML markup for upgrade doc addition.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dff20=

- Update pg_upgrade docs to mention its use in a less risk-warning
way, and update the pg_upgrade docs to mention its reliance on no
changes to the storage format (the later based on Robert Haas's
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4945=

- Fix pg_upgrade to create pg_authid restore functions in the
'postgres' database, not in the os-user database, per report from
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6238=

- In pg_authid.rolpassword docs, make "md5" appear as a literal.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2dbe=

- Improve docs for pg_authid encryption description with better markup
and a mention of unencrypted passwords.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D00dd=

- Add pg_upgrade comment for why we can't use template1 inheritance
for the support functions.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2bb8=

- Add missing period "." in pg_upgrade documentation.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd288=

- Clarify pg_upgrade install instructions, per suggestion from Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D902a=

- Document that Slony can do upgrades easier _because_ it supports
replication between different Postgres major versions.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3De8cd=

- Document that effective cache size does not assume data remains in
the cache between queries.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6c6e=

- Clarify documentation to state that "zero_damaged_pages" does not
force data to disk, so the table or index should be recreated before
the parameter is turned off again.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7106=

- Properly capitalize hyphenated words in documentation titles.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd56d=

- Document that CREATE VIEW that uses "*" for the column list will not
auto-add columns later added to the base table.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5a6b=

- Simplify pg_upgrade checking of executable permissions.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9d22=

- Fix wrong verb in pg_upgrade text message, per Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2b6e=

- Mark all GUC variables with markup, rather than .
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D03c2=

- Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is a
path variable, not a directory path.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dbffb=

- Rename function to first_path_var_separator() to clarify it works
with path variables, not directory paths.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4262=

- Simplify code used in is_absolute_path() macro; also add comment
about 'E:abc' Win32 path handling.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D35b0=

- In docs, PL is Procedural Language, not Programming Language.
Satoshi Nagayasu.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ddf63=

- ALTER TABLE sometimes takes only ShareUpdateExclusiveLock. Along
the way, be more consistent about the wording we use here.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7212=

- In docs, move PQrequestCancel() deprecation mention up to match
other libpq doc mentions.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db157=

- Add doc comment that installation.sgml can't use xrefs.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8e6a=

- Add C comment about why older compilers complain about
basebackup.c's longjump.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D51db=

- Rename macro DECIMAL to DECIMAL_T to help pgindent; this is already
done for a few other macros in that file, for other reasons. I also
remove pgindent/README mention of the file.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9711=

- Adjust libpq docs to be clearer about 'hostaddr' usage by rewording
and using an itemized list.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5ed4=

Andrew Dunstan pushed:

- Update docs on building for Windows to accomodate current reality.
Document how to build 64 bit Windows binaries using the MinGW64 tool
set. Remove recommendation against using Mingw as a build platform.
Be more specific about when Cygwin is useful and when it's not, in
particular note its usefulness for running psql, and add a note
about building on Cygwin in non-C locales. Per recent discussions.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D51be=

- Set up PLPerl trigger data using C code instead of Perl code. This
is an efficiency change, and means we now no longer have to run "out
$_TD; local $_TD =3D shift;", which was especially pointless in the
case of non-trigger functions where the passed value was always
undef anyway. A tiny open issue is whether we should get rid of the
$prolog argument of mkfunc, and the corresponding pushed value,
which is now just a constant "false". Tim Bunce, reviewed by Alex
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Def19=

- Add comment on why we're passing a useless 'false' to the plperl
function compiler. It's for compatibility with modules like
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc73f=

- Attempt to unbreak MSVC builds after pipe.c move.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D895a=

- Force strings passed to and from plperl to be in UTF8 encoding.
String are converted to UTF8 on the way into perl and to the
database encoding on the way back. This avoids a number of observed
anomalies, and ensures Perl a consistent view of the world. Some
minor code cleanups are also accomplished. Alex Hunsaker, reviewed
by Andy Colson.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D50d8=

Simon Riggs pushed:

- Fix error code for canceling statement due to conflict with
recovery. All retryable conflict errors now have an error code that
indicates that a retry is possible, correcting my incomplete fix of
2010/05/12 Tatsuo Ishii and Simon Riggs, input from Robert Haas and
Florian Pflug
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8585=

- Create new errcode for recovery conflict caused by db drop on
master. Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is
now reported as ERRCODE_T_R_DATABASE_DROPPED. No message text
change. Unlikely to happen on most servers, so low impact change to
allow session poolers to correctly handle this situation. Tatsuo
Ishii, edits by me, review by Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9e95=

http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D56b2=

Tom Lane pushed:

- Prevent buffer overrun while parsing an integer in a "query_int"
value. contrib/intarray's gettoken() uses a fixed-size buffer to
collect an integer's digits, and did not guard against overrunning
the buffer. This is at least a backend crash risk, and in principle
might allow arbitrary code execution. The code didn't check for
overflow of the integer value either, which while not presenting a
crash risk was still bad. Thanks to Apple Inc's security team for
reporting this issue and supplying the fix. Security: CVE-2010-4015
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7ccb=

- Update release notes. Security: CVE-2010-4015
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4305=

- Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.
Unlike Btree-based LIKE optimization, this works for
non-left-anchored search patterns. The effectiveness of the search
depends on how many trigrams can be extracted from the pattern.
(The worst case, with no trigrams, degrades to a full-table scan, so
this isn't a panacea. But it can be very useful.) Alexander
Korotkov, reviewed by Jan Urbanski.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6e2f=

- Clean up missed change to plpython expected files.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9078=

- Repair multiple breakage in Windows-specific code for appending '.exe'.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dcd7d=

ITAGAKI Takahiro pushed:

- Add a link from client_encoding parameter to the list of character
sets in documentation. Thom Brown
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0328=

- Fix wrong error reports in 'number of array dimensions exceeds the
maximum allowed' messages, that have reported one-less dimensions.
Alexey Klyukin
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0c70=

Magnus Hagander pushed:

- Undefine setlocale() macro on Win32. New versions of libintl
redefine setlocale() to a macro which causes problems when the
backend and libintl are linked against different versions of the
runtime, which is often the case in msvc builds. Hiroshi Inoue,
slightly updated comment by me
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5273=

- Fix typo. Thom Brown
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df001=

- Include more status information in walsender results. Add the
current xlog insert location to the response of IDENTIFY_SYSTEM, and
adds result sets containing start and stop location of backups to
BASE_BACKUP responses.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7612=

- Use single quotes when there are backslashes in the filename. In
the hope of unbreaking the buildfarm
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D39fb=

- Attempt to un-break the documentation build again Another case of
in the documentation that builds INSTALL, which is
not allowed.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dafb6=

- IDENTIFY_SYSTEM now returns 3 fields, not 2
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dcedd=

Peter Eisentraut pushed:

- Add validator to PL/Python. Jan Urbański, reviewed by Hitoshi
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D15f5=

- Wrap PL/Python SPI calls into subtransactions. This allows the
language-specific try/catch construct to catch and handle exceptions
arising from SPI calls, matching the behavior of other PLs. As an
additional bonus you no longer get all the ugly "unrecognized error
in PLy_spi_execute_query" errors. Jan Urbański, reviewed by =
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0c59=

Robert Haas pushed:

- Log restartpoints in the same fashion as checkpoints. Prior to 9.0,
restartpoints never created, deleted, or recycled WAL files, but now
they can. This code makes log_checkpoints treat checkpoints and
restartpoints symmetrically. It also adjusts up the documentation
of the parameter to mention restartpoints. Fujii Masao. Docs by
me, as suggested by Itagaki Takahiro.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0af6=

- Various sepgsql corrections. KaiGai Kohei
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc768=

- Minor sepgsql regression test fixes.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D87d9=

- sepgsql doc fix. KaiGai Kohei
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4ff9=

- Further sepgsql documentation cleanup.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4c4d=

- Avoid maintaining three separate copies of the error codes list.
src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a
big chunk of errcodes.sgml are now automatically generated from a
single file, src/backend/utils/errcodes.txt. Jan Urbański, r=
by Tom Lane.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dddfe=

- Preserve copyright notice from old errcodes.h file.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db8a0=

- Unbreak the VPATH build. My commit
ddfe26f6441c24660595c5efe5fd0bd3974cdc5c of 2010-02-03 broke it.
Per buildfarm.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ddde9=

- Unbreak 'configure' followed immediately by 'make install'. More
fallout from ddfe26f6441c24660595c5efe5fd0bd3974cdc5c. Report by
Fujii Masao.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db878=

- Make handling of errcodes.h more consistent with other generated
headers. This fixes make distprep, and seems more robust in other
ways as well. Some special handling is required because
errcodes.txt is needed by some stuff in src/port, but just by
src/backend as is the case for the other generated headers. While
I'm at it, fix a few other things that were overlooked in the
original patch.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D356f=

- Use $(MAKE) rather than make. Per buildfarm.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6f59=

- Update ALTER TABLE docs to mention using VACUUM FULL for rewrites.
Remove the claim that ALTER TABLE .. SET DATA TYPE is the fastest
way of rewriting a table, since it no longer is. Noah Misch and
Robert Haas, based on a suggestion from Tom Lane.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dedad=

- Avoid including postgres.h in frontend compiles of src/port. This
isn't kosher, and doesn't play nicely with my recent changes to the
Makefile in this directory.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8201=

- Move pipe.c into the backend. It's full of backend-specific error
reporting, so it's neither possible nor necessary for this to be
used from frontend code.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db1e6=

- Clarify comment in ATRewriteTable(). Make sure it's clear that the
prohibition on adding a column with a default when the rowtype is
used elsewhere is intentional, and be a bit more explicit about the
other cases where we perform this check.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9e7e=

- Tighten ALTER FOREIGN TABLE .. SET DATA TYPE checks. If the foreign
table's rowtype is being used as the type of a column in another
table, we can't just up and change its data type. This was already
checked for composite types and ordinary tables, but we previously
failed to enforce it for foreign tables.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6537=

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Greg Smith sent in another revision of the patch to do spread
checkpoint syncs.

Marko (johto) Tiikkaja sent in another revision of the patch to add
transaction-scoped advisory locks.

Joachim Wieland sent in another revision of that patch to do parallel
pg_dump using a new directory-based format.

Simon Riggs sent in a patch to add a FORCE option to DROP DATABASE.

ITAGAKI Takahiro sent in another revision of the patch to add

Fujii Masao sent in a patch to change pg_stop_backup so that it only
creates the backup history file if archiving is enabled.

Alexey Klyukin sent in another revision of the patch to transform
between PostgreSQL arrays and Perl arrays in PL/Perl.

Hitoshi Harada sent in three more revisions of the patch to add

Euler Taveira de Oliveira sent in another revision of the patch to add
named restore points.

Peter Eisentraut sent in another revision of the patch to add
per-column collations.

ITAGAKI Takahiro and Dimitri Fontaine traded patches to add support
for EXTENSIONs to pg_dump.

Kevin Grittner sent in another revision of the patch to add
SSI (serializable snapshot isolation).

Heikki Linnakangas sent in a patch to add regression tests for SSI.

YAMAMOTO Takahashi sent in another revision of the patch to avoid
de-TOAST'ing large objects.

Andrew Dunstan sent in a patch to the docs to describe how to build
PostgreSQL for Win64 using certain toolkits.

Dimitri Fontaine sent in another revision of the ALTER EXTENSION

Tomas Vondra and Greg Smith traded patches to keep the timestamp of
the latest stats reset.

Magnus Hagander sent in three revisions of a patch to move the WAL

Bruce Momjian sent in a patch to simplifiy the pg_upgrade executable
checks per suggestion from Robert Haas.

Robert Haas sent in another revision of the patch to limit hint bit

Bruce Momjian sent in two more revisions of the patch to fix
is_absolute_path on Windows.

ITAGAKI Takahiro sent in a patch to implement a jagged row CSV API, to
be applied atop Andrew Dunstan's patch to expose the COPY API.

Thom Brown sent in a patch to fix an issue where generate_series()
misbehaved by returning if the series hits either the upper or lower
boundary during increment, or goes beyond it, none of which should

Jan Urbanski sent in another flock of patches to improve PL/Python.

Robert Haas sent in another revision of the patch to skip table
rewrites in cases where it can be proven that this will not actually
change anything when someone issues an ALTER TABLE.

Alex Hunsaker sent in another revision of the patch to convert
between PostgreSQL arrays an Perl arrays in PL/Perl.

Stephen Frost sent in another revision of the patch to allow logging
the current role.

Jeff Davis sent in another revision of the patch to add range types.

Simon Riggs sent in a patch to fix commit performance in SAVEPOINTs,
which had O(n^2) behavior.

Bruce Momjian sent in a doc patch for Streaming Replication.

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

Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription: