== Wöchentlicher PostgreSQL Newsletter - 30. Januar 2011 ==

== Wöchentlicher PostgreSQL Newsletter - 30. Januar 2011 ==

am 02.02.2011 00:16:02 von adsmail

Der Originalartikel befindet sich unter:


== Wöchentlicher PostgreSQL Newsletter - 30. Januar 2011 ==

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:

== PostgreSQL Produkt Neuigkeiten ==

DBSolo 4.0, ein SQL Query Werkzeug, das PostgreSQL
unterstützt, ist erschienen.

PostgreSQL Maestro 11.1, ein Windows Administrationswerkzeug
für PostgreSQL, ist erschienen.

OpenSCG PostgreSQL + Java Stacks (Glassfish 3.0.1/PostgreSQL 9.0.2
und Jboss 6.0.0 (GA) / PostgreSQL 9.0.2) sind erschienen.

tail_n_mail 1.17.5, ein Programm zum Überwachen von
Logdateien, ist erschienen.

== PostgreSQL Jobs im Januar ==

http://archives.postgresql.org/pgsql-jobs/2011-01/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.

Der PostgreSQLFr Call for Projects ist offen. Projekte müssen
PostgreSQL und die französisch-sprechende Community ansprechen.
Maile an appel-projets-2010 AT postgresql DOT fr.
http://www.postgresql.fr/appel_a_projets_2010:call_for_proje cts

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

ITAGAKI Takahiro reviewed the log_csv_options patch.

Fujii Masao reviewed the patch to allow base backup to include WALs.

ITAGAKI Takahiro reviewed the patch to support EXTENSIONs in pg_dump.

Jeff Davis reviewed the patch to add truly SERIALIZABLE transactions.

Steve Singer reviewed the patch to use subtransactions in PL/PythonU.

== Applied Patches ==

Magnus Hagander pushed:

- Exclude sepgsql from MSVC regression testing as well. In passing,
change exclusion in the build to follow the same pattern as other
always-excluded modules.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9752=

- Typo fix for MemSet size. Fujii Masao.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D966d=

- Use GSSAPI library for SSPI auth, when native SSPI is not available.
This allows non-Windows clients to connect to a Windows server with
SSPI authentication. Christian Ullrich, largely modified by me
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4ea1=

- Add option to include WAL in base backup. When included, this makes
the base backup a complete working "clone" of the initial database,
ready to have a postmaster started against it without the need to
set up any log archiving or similar. Magnus Hagander, reviewed by
Fujii Masao and Heikki Linnakangas
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5070=

Heikki Linnakangas pushed:

- Fix typo in the psql \d query handling, so that we use the correct
query against 9.0 servers.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D74be=

- Update psql's \copyright to match the text we have in the COPYRIGHT
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D1e4b=

Robert Haas pushed:

- More documentation cleanup for sepgsql. Thom Brown and Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dea2c=

- Fix thinko in ALTER FOREIGN TABLE documentation. Noah Misch.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D558d=

- Correct ALTER TYPE -> SET DATA TYPE in ALTER TABLE documentation.
The latter is the correct name of the operation to change the data
type of a column. Noah Misch.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2b2b=

- Remove arbitrary ALTER TABLE .. ADD COLUMN restriction. The
previous coding prevented ALTER TABLE .. ADD COLUMN from being used
with a non-NULL default in situations where the table's rowtype was
being used elsewhere. But this is a completely arbitrary
restriction since you could do the same operation in multiple steps
(add the column, add the default, update the table). Inspired by a
patch from Noah Misch, though I didn't use his code.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Da06e=

- Add a comment explaining why we force physical removal of OIDs.
Noah Misch, slightly revised.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5c2a=

- Restore ALTER TABLE .. ADD COLUMN w/DEFAULT restriction. This
reverts commit a06e41deebdf74b8b5109329dc75b2e9d9057962 of
2011-01-26. Per discussion, this behavior is not wanted, as it
would need to change if we ever made composite types support
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Da40b=

- Try to avoid running with a full fsync request queue. When we need
to insert a new entry and the queue is full, compact the entire
queue in the hopes of making room for the new entry. Doing this on
every insertion might worsen contention on BgWriterCommLock, but
when the queue it's full, it's far better than allowing the backend
to perform its own fsync, per testing by Greg Smith as reported in
http://archives.postgresql.org/pgsql-hackers/2011-01/msg0266 5.php
Original idea from Greg Smith. Patch by me. Review by Chris Browne
and Greg Smith
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7f24=

Peter Eisentraut pushed:

- Refactor PLy_spi_prepare to save two levels of indentation. Instead
of checking whether the arglist is NULL and then if its length is 0,
do it in one step, and outside of the try/catch block. Jan UrbaÅ=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5271=

- Call PLy_spi_execute_fetch_result inside the try/catch block. This
way errors from fetching tuples are correctly reported as errors in
the SPI call. While at it, avoid palloc(0). Jan Urbański
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D88dc=

- Document the "S" option for psql's \dn command in the psql help.
This option was recently introduced, but the documentation in help.c
was not updated.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D77ff=

- Fix compiler warnings. Older versions of GCC appear to report these
with the current standard option set, newer versions need
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dddf8=

- autoreconf. Synchronize pg_config.h.in with configure.in (someone
must have forgotten to run autoheader or autoreconf), and clean up
some spurious change in configure introduced by the last commit
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6fe5=

- Improve exception usage in PL/Python. Use the built-in TypeError,
not SPIError, for errors having to do with argument counts or types.
Use SPIError, not simply plpy.Error, for errors in
PLy_spi_execute_plan. Finally, do not set a Python exception if
PyArg_ParseTuple failed, as it already sets the correct exception.
Jan Urbański
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D582b=

- Do not prefix error messages with the string "PL/Python: " It is
redundant, given the error context. Jan Urbański
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5829=

- Use -Wformat-security when available.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8b6f=

- Also save the error detail in SPIError. The temporarily broken
plpython_unicode test shows a case where this is used. Do remaining
fix-ups on the expected files at the same time.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D418d=

- Translation updates for release 9.0.3, 8.4.7, 8.3.14, 8.2.20.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7f2d=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dbdf3=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3De7a1=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd5a0=

Bruce Momjian pushed:

- In test_open_sync(), writes kilobytes as intended, not by bytes.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9fc0=

- Use XLOG_BLCKSZ in pg_test_fsync, rather than our own define, but
verify it is 8k as expected.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9dd7=

- Use consistent spacing for PGAPPICON Makefile option.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd7a7=

- Update warning about synchronous-commit durability, per suggestion
from Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Da91c=

- Adjust pg_test_fsync to always do XLOG_BLCKSZ-sized writes, rather
than always 8k writes, per suggestion from Tom Lane. Also adjust
open_sync output layout.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D64bc=

- Update sync commit performance documentation to be consistent with
other non-durable items, per Robert Haas.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3De847=

- Update contrib documention mentions to point to actual documentation
sections, rather than just calling it "/contrib/module_name". Also
update pg_test_fsync build instructions now that it is in /contrib.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D159e=

- In pg_test_fsync, use K(1024) rather than k(1000) for write size
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0086=

- Per Peter Eisentraut, use 'kB' for kilobyte, not 'K'.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4fec=

- Restructure streaming docs so streaming seems more integrated in the
paragraphs, per suggestion from Dan Birken.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D81c4=

- Update non-durable docs about non-synchronous-commit allowing
transaction loss for a _database_ crash.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db34e=

- Properly capitalize documentation headings; some only had
initial-word capitalization.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5d56=

Tom Lane pushed:

- Replace pg_class.relhasexclusion with pg_index.indisexclusion.
There isn't any need to track this state on a table-wide basis, and
trying to do so introduces undesirable semantic fuzziness. Move the
flag to pg_index, where it clearly describes just a single index and
can be immutable after index creation.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dbd1a=

- Remove old claim that ExclusiveLock is sometimes taken on system
catalogs. We used to do that on pg_listener, but pg_listener is no
more. Also add a bit more documentation for ShareRowExclusive mode.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5042=

- Change inv_truncate() to not repeat its systable_getnext_ordered()
scan. In the case where the initial call of
systable_getnext_ordered() returned NULL, this function would
nonetheless call it again. That's undefined behavior that only by
chance failed to not give visibly incorrect results. Put an if-test
around the final loop to prevent that, and in passing improve some
comments. No back-patch since there's no actual failure. Per
report from YAMAMOTO Takashi.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7ab6=

- Improve grammar and spelling in durability discussion.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D85f3=

- Update release notes for releases 9.0.3, 8.4.7, 8.3.14, and 8.2.20.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D29d4=

- Don't include unnecessarily. We only need that
header when compiling with icc, since the gcc variant of
ia64_get_bsp() uses in-line assembly code. Per report from Frank
Brendel, the header doesn't exist on all IA64 platforms; so don't
include it unless we need it.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D0ac8=

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

- Rephrase pg_conversion description to avoid splitting link across
page. The link to the CREATE CONVERSION manual page was split
across a page boundary in the PDF output, leading to "\pdfendlink
ended up in different nesting level than \pdfstartlink" error while
building PDFs. It wouldn't be worth changing text that's undergoing
active editing to avoid this, since other editing might result in
moving the link away from the page end anyway. But this paragraph
has been static for a long time, so might as well fix it to prevent
it from being an issue in future.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D20a0=

- Copy-edit a paragraph in the contrib/seg documentation. Although
this improves the style, an ulterior motive is to keep the two table
links from breaking across lines in PDF output, per complaint from
Josh Kupershmidt.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db282=

- Make installation.sgml build standalone again. We must not try to
link to sections that aren't part of the standalone "make INSTALL"
build. Corrects build failure introduced in commit
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6f48=

- Make reduce_outer_joins() smarter about semijoins.
reduce_outer_joins() mistakenly treated a semijoin like a left join
for purposes of deciding whether not-null constraints created by the
join's quals could be passed down into the join's left-hand side
(possibly resulting in outer-join simplification there). Actually,
semijoin works like inner join for this purpose, ie, we do not need
to see any rows that can't possibly satisfy the quals. Hence,
two-line fix to treat semi and inner joins alike. Per observation
by Andres Freund about a performance gripe from Yazan Suleiman.
Back-patch to 8.4, since this oversight has been there since the
current handling of semijoins was implemented.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9688=

ITAGAKI Takahiro pushed:

- Make 'on' uppercase in a sql example.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D6903=

Marc Fournier pushed:

- Tag 9.0.3. 8.4.7, 8.3.14, 8.2.20.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2fb6=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7df9=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5370=
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df62f=

Andrew Dunstan pushed:

- Enable building with the Mingw64 compiler. This can be used to
build 64 bit Windows binaries, not only on 64 bit Windows but on
supported cross-compiling hosts including 32 bit Windows, Cygwin,
Darwin and Linux.
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9181=

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

== Abgelehnte Patches (bis jetzt) ==

Marko (johto) Tiikkaja's patch to add filtering details to EXPLAIN.
Not added to enough places -> returned with feedback.

== Eingesandte Patches ==

Pavel Stehule sent in another revision of the patch to add FOREACH ...
IN ARRAY to PL/pgsql.

ITAGAKI Takahiro sent in another revision of the patch to add

Dimitri Fontaine and ITAGAKI Takahiro traded revisions of the patch to
add EXTENSION support to pg_dump.

Magnus Hagander sent in a patch to allow pg_basebackup to send WALs.

Heikki Linnakangas sent in two more revisions of the patch to allow
multiple concurrent base backups.

Noah Misch sent in two more revisions of the patch to turn no-work
table rewrites caused by ALTER TABLE into no-ops.

Kevin Grittner sent in four more revisions of the patch to add true

Fujii Masao sent in a patch to ensure that logging restartpoints also
implies logging WALs created/deleted/recycled, just as log_checkpoints

KaiGai Kohei sent in two more patches to fix the sepgsql contrib

Alex Hunsaker sent in two more revisions of the patch to convert
between PostgreSQL and Perl arrays in PL/Perl.

Jan Urbanski sent in two more revisions of the patch to fix PL/PythonU
table functions.

Kevin Grittner sent in two revisions of a patch to add .gitignore
files appropriate to coverage builds.

Jan Urbanski sent in another revision of the PL/Python validator
function, per review from Hitoshi Harada.

Jan Urbanski sent in five more revisions of the patch to use SPI in
PL/Python subtransactions.

Jan Urbanski sent in another revision of the patch to have PL/PythonU
immediately invalidate functions with composite arguments.

Jan Urbanski sent in another revision of the patch to implement
tracebacks in PL/PythonU.

Jan Urbanski sent in another revision of the patch to implement custom
datatype parsers for PL/PythonU.

Jan Urbanski sent in another revision of the patch to implement custom
exceptions for SPI in PL/PythonU.

Jeff Davis sent in two more revisions of the patch to add range types.

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

Andrew Dunstan sent in a patch to get PostgreSQL running on the
Mingw64 toolset on 64-bit Windows7Pro.

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

Alexander Korotkov sent in two more revisions of the patch to add
wildcard searches to the trigram system-supplied module.

Robert Haas sent in another revision of the patch to generate error
code lists automatically.

Joachim Wieland sent in another revision of the patch to allow for
synchronized snapshots per suggestions from Noah Misch.

Kevin Grittner sent in a patch to track trigger depth for 9.2.

Pavel Stehule sent in another patch to add FOREACH ... IN [array] to

Robert Haas sent in another patch to allow logging of aborted vacuums.

Robert Haas sent in another revision of the patch to spread disk

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: