== Wöchentlicher PostgreSQL Newsletter - 19. Dezember 2010 ==

== Wöchentlicher PostgreSQL Newsletter - 19. Dezember 2010 ==

am 20.12.2010 16:12:25 von adsmail

Der Originalartikel befindet sich unter:

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



== Wöchentlicher PostgreSQL Newsletter - 19. Dezember 2010 ==

PostgreSQL Updates 9.0.2, 8.4.6, 8.3.13, 8.2.19, 8.1.23
veröffentlicht. Wenn Sie Hot oder Warm Standby oder PITR einsetzen,
sollten Sie so schnell wie möglich updaten. Die Version 8.1 hat
nun ihr Lebensende erreicht, alle Anwender werden aufgefordert,
so schnell wie möglich auf eine neuere Version zu aktualisieren.
http://www.postgresql.org/docs/9.0/static/release.html

Reiche einen Vortrag für PGCon 2011 ein.
http://lists.pgcon.org/pipermail/pgcon-announce/2010-Decembe r/000065.html

Der Call for Papers für den vierten Prager
Development Day ist eröffnet. Die Veranstaltung
findet am 10. Februar 2011 an der Charles
Universität in Prag statt.
http://archives.postgresql.org/pgsql-announce/2010-12/msg000 09.php

PostgreSQL Conference East 2011: New York,
vom 22. bis 25. März
http://www.postgresqlconference.org

== PostgreSQL Produkt Neuigkeiten ==

DBD::Pg 2.17.2, ein Perl Treiber für
PostgreSQL, ist erschienen.
http://search.cpan.org/dist/DBD-Pg/

devart dotConnect für PostgreSQL, ein
ADO.NET Treiber, ist erschienen.
http://www.devart.com/dotconnect/postgresql/

MicroOLAP hat PaGoDump und PaGoRestore mit
Support für PostgreSQL 9.0 veröffentlicht.
http://microolap.com/products/database/pagodump/download/

PGSI 1.5.0, ein Werkzeug welches die gesamten
Auswirkungen einer Anfrage an PostgreSQL auf den
Server protokolliert, wurde veröffentlicht.
http://bucardo.org/wiki/Pgsi

phpPgAdmin 5.0.1, ein webbasiertes Administrationstool für
PostgreSQL, ist erschienen.
http://phppgadmin.sourceforge.net/

Gedruckte Versionen des PostgreSQL 9.0.1
Handbuchs sind verfügbar.
http://www.network-theory.co.uk/postgresql9/

Data Visualization 0.9.2, welches PostgreSQL
unterstützt, ist erschienen.
http://sites.google.com/site/datavisualizationapplication/

== PostgreSQL Jobs im Dezember ==

http://archives.postgresql.org/pgsql-jobs/2010-12/threads.ph p

== PostgreSQL Lokal ==

The PostgreSQLFr Call for Projects has begun. Projects must target
PostgreSQL and the French-speaking community. Mail appel-projets-2010
AT postgresql DOT fr.
http://www.postgresql.fr/appel_a_projets_2010:call_for_proje cts

FOSDEM ist eine der größten Freien und Open Source Veranstaltungen
und findet jährlich in Brüssel, Belgien statt, nächstes Jahr=
am
5. und 6. Februar 2011. Ungefähr 4.000 Besucher finden sich dort ein.
Sende deine Vorträge an fosdem AT postgresql DOT eu.
http://andreas.scherbaum.la/blog/archives/749-PostgreSQLFOSD EM-2011-Call-fo=
r-talks.html

PGDay findet dieses Jahr während der südkalifornischen Linux Auss=
tellung
(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.

PGCon will be May 19-20, 2011 at the University of Ottawa, preceded by
two days of tutorials on May 17-18.
http://www.pgcon.org/2011/

== PostgreSQL in den News ==

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

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

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

Robert Haas pushed:

- Generalize concept of temporary relations to "relation persistence".
This commit replaces pg_class.relistemp with
pg_class.relpersistence; and also modifies the RangeVar node type to
carry relpersistence rather than istemp. It also removes removes
rd_istemp from RelationData and instead performs the correct
computation based on relpersistence. For clarity, we add three new
macros: RelationNeedsWAL(), RelationUsesLocalBuffers(), and
RelationUsesTempNamespace(), so that we can clarify the purpose of
each check that previous depended on rd_istemp. This is intended as
infrastructure for the upcoming unlogged tables patch, as well as
for future possible work on global temporary tables.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5f7b=
58fad8f45c69bb67944779dce67e2f481995

- Document replacement of pg_class.relistemp with relpersistence.
Noted by Tom Lane.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd268=
49ee26e46a689fb7c228f98e10fb46c1b2a8

- Allow plugins to suppress inlining and hook function
entry/exit/abort. This is intended as infrastructure to allow an
eventual SE-Linux plugin to support trusted procedures. KaiGai
Kohei.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd368=
e1a2a7afad5a0fc711a2ab70a83c36fa57af

- Improved tab completion for views with triggers. Allow INSERT INTO,
UPDATE, and DELETE FROM to be completed with either the name of a
table (as before) or the name of a view with an appropriate INSTEAD
OF rule. Along the way, allow CREATE TRIGGER to be completed with
INSTEAD OF, as well as BEFORE and AFTER. David Fetter, reviewed by
Itagaki Takahiro
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D9878=
e295dc937c664367875dc001b7503df057f1

- Instrument checkpoint sync calls. Greg Smith, reviewed by Jeff
Janes.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D34c7=
0c7ac4926495b7ab5ebfe748704313a4c822

- Document timestamptz a little better.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dafc8=
f47b5885716db716a2523c00f7465cb7f415

- Some copy editing of pg_read_binary_file() patch.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D290f=
1603b4208ca6a13776f744b586a958e98d74

- Waiting for complete startup is now a well-defined operation. Per
report from Fujii Masao, and subsequent discussion.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ddf14=
2bf82c84de5d0588ae7d52881501abb039ed

- Reset 'ps' display just once when resolving VXID conflicts. This
prevents the word "waiting" from briefly disappearing from the ps
status line when ResolveRecoveryConflictWithVirtualXIDs begins a new
iteration of the outer loop. Along the way, remove some useless
pgstat_report_waiting() calls; the startup process doesn't appear in
pg_stat_activity. Fujii Masao.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D611f=
ed371227f430e71d0ff7fed037f1006b410d

- Try to save a kernel call in ResolveRecoveryConflictWithVirtualXIDs.
If there's no work to be done, just exit quickly, before initialization.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8bd4=
b89e240cc6488f5e1523202cc2d27e9970c0

Tom Lane pushed:

- Update time zone data files to tzdata release 2010o: DST law changes
in Fiji and Samoa. Historical corrections for Hong Kong.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df5e4=
f743e6a84884156ac86948277df4c672865c

- Update release notes for releases 9.0.2, 8.4.6, 8.3.13, 8.2.19, and
8.1.23.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df922=
4c8ec2f6dcfed6daa3f94597b870ec31c8d8

- Fix contrib/seg's GiST picksplit method. This patch replaces
Guttman's generalized split method with a simple
sort-by-center-points algorithm. Since the data is only
one-dimensional we don't really need the slow and none-too-stable
Guttman method. This is in part a bug fix, since seg has the same
size_alpha versus size_beta typo that was recently fixed in
contrib/cube. It seems prudent to apply this rather aggressive fix
only in HEAD, though. Back branches will just get the typo fix.
Alexander Korotkov, reviewed by Yeb Havinga.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2a6e=
be70fb2f7ec97a08dc07214fe2ca571d2780

- Fix up getopt() reset management so it works on recent mingw. The
mingw people don't appear to care about compatibility with non-GNU
versions of getopt, so force use of our own copy of getopt on
Windows. Also, ensure that we make use of optreset when using our
own copy. Per report from Andrew Dunstan. Back-patch to all
versions supported on Windows.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5cdd=
65f3241ce10c66953228daef60df7b3966d1

- Remove optreset from src/port/ implementations of getopt and
getopt_long. We don't actually need optreset, because we can easily
fix the code to ensure that it's cleanly restartable after having
completed a scan over the argv array; which is the only case we need
to restart in. Getting rid of it avoids a class of interactions
with the system libraries and allows reversion of my change of
yesterday in postmaster.c and postgres.c. Back-patch to 8.4.
Before that the getopt code was a bit different anyway.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D61b5=
3695fbbedb7fa9d394e71bf2affdc494e6b0

- Improve comments around startup_hacks() code. These comments were
not updated when we added the EXEC_BACKEND mechanism for Windows,
even though it rendered them inaccurate. Also unify two
unnecessarily-separate #ifdef __alpha code blocks.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D14ed=
7735f5bb5275da13891c4bb106c198d00b53

- Fix erroneous parsing of tsquery input "... & !(subexpression) |
..." After parsing a parenthesized subexpression, we must pop all
pending ANDs and NOTs off the stack, just like the case for a simple
operand. Per bug #5793. Also fix clones of this routine in
contrib/intarray and contrib/ltree, where input of types query_int
and ltxtquery had the same problem. Back-patch to all supported
versions.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dabc1=
0262696e53773c9a8c9f279bbd464b464190

- Fix up handling of simple-form CASE with constant test expression.
eval_const_expressions() can replace CaseTestExprs with constants
when the surrounding CASE's test expression is a constant. This
confuses ruleutils.c's heuristic for deparsing simple-form CASEs,
leading to Assert failures or "unexpected CASE WHEN clause" errors.
I had put in a hack solution for that years ago (see commit
514ce7a331c5bea8e55b106d624e55732a002295 of 2006-10-01), but bug
#5794 from Peter Speck shows that that solution failed to cover all
cases. Fortunately, there's a much better way, which came to me
upon reflecting that Peter's "CASE TRUE WHEN" seemed pretty
redundant: we can "simplify" the simple-form CASE to the general
form of CASE, by simply omitting the constant test expression from
the rebuilt CASE construct. This is intuitively valid because there
is no need for the executor to evaluate the test expression at
runtime; it will never be referenced, because any CaseTestExprs that
would have referenced it are now replaced by constants. This won't
save a whole lot of cycles, since evaluating a Const is pretty
cheap, but a cycle saved is a cycle earned. In any case it beats
kluging ruleutils.c still further. So this patch improves
const-simplification and reverts the previous change in ruleutils.c.
Back-patch to all supported branches. The bug exists in 8.1 too,
but it's out of warranty.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D1b19=
e2c0baedb959650a27f25bd8537bd51d60b0

Peter Eisentraut pushed:

- Translation updates for 9.0.2, 8.4.6, 8.3.13, 8.2.19, 8.1.23.

- Remove recently reintroduced CVS keyword
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D843a=
490f0aeccd5b61a30c37d2ffaae26d192329

Marc Fournier pushed:

- Tag 9.0.2, 8.4.6, 8.3.13, 8.2.19, 8.1.23.

Bruce Momjian pushed:

- Use "upgrade" in preference over "migrate" in pg_upgrade messages
and documentation. (Many were left over from the old pg_migrator
naming.)
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D16b5=
e08decc8207ae35589add387dce9b62669de

- Fix crash caused by NULL lookup when reporting IP address of failed
libpq connection, per report from Magnus. This happens only on GIT
master and only on Win32 because that is the platform where "" maps
to an IP address (localhost).
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D48da=
2b87e3f292534a26d3bacc2a13f7b62a34c8

- Properly print the IP number and "localhost" for failed localhost
connections when the server is down, on Win32.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7e95=
337d586185c91f8af3fbcb0a6b380b4ba1c7

ITAGAKI Takahiro pushed:

- Add pg_read_binary_file() and whole-file-at-once versions of
pg_read_file(). One of the usages of the binary version is to read
files in a different encoding from the server encoding. Dimitri
Fontaine and Itagaki Takahiro.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D03db=
44eae3e065174d5e29888b8d98c39b1f520b

Alvaro Herrera pushed:

- Add some minor missing error checks.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3De359=
b8496d11befb63d4734874d997909c44ad83

- Simplify SignalSomeChildren(BACKEND_TYPE_ALL) to SignalChildren().
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D16ca=
75baebc56cebc6590691a0b474ee1922519c

- Fix inconsequential FILE pointer leakage.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D83c7=
59ea0ea8ffe07c45e6fd2c489cebce2caad6

- Avoid clobbering errno, per comment from Tom Lane.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dcd1f=
efa973968ff4e3760a9593f70fe2da0def48

- Remove unnecessary definition for autovacuum in SignalSomeChildren.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Db681=
93c0c7a7cfbc4aead3910cd492be63c0cd8b

- set_ps_display when calling functions via fastpath. This improves
tag output by log_line_prefix.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D3026=
027ec3a795745e8e80fc9f204bebc97be58e

Andrew Dunstan pushed:

- Backpatch plperl GNUmakefile fixes to allow building release 8.2 on
Mingw with a modern perl.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df2f6=
3551cdafcdec4169557122522229aa2530e8

- Work around make changes on modern Mingw to allow release 8.2
regression tests to work.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D43a7=
206fcca3f77503be481565b2a855b9044550

Magnus Hagander pushed:

- Make GUC variables for syslog and SSL always visible. Make the
variables visible (but not used) even when support is not compiled in.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4754=
dbf4c3f857a496b0d29af74786c73d1a8401

- Document unavailable parameters in some configurations. Add a note
to user-facing parameters that can be removed completely (and not
just empty) by #ifdef's depending on build configuration.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D8b4d=
3d44dc7d64aaafd2269d3da8d2873137c691

- Support for collecting crash dumps on Windows. Add support for
collecting "minidump" style crash dumps on Windows, by setting up an
exception handling filter. Crash dumps will be generated in
PGDATA/crashdumps if the directory is created (the existance of the
directory is used as on/off switch for the generation of the dumps).
Craig Ringer and Magnus Hagander.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ddcb0=
9b595f88a3bca6097a6acc17bf2ec935d55f

- Remove thread dumping constant that requires newer Platform SDK.
Since we're not multithreaded it only provides marginally useful
information, and it does require a newer version of the Platform SDK
than we target. We may want to reconsider this in the future along
with a fix for MinGW.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd382=
828f6ed1edc0f123934d53c52065ecc425c9

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Gurjeet Singh sent in a patch with an improved syntax for adding a
primary key using an existing index.

Heikki Linnakangas sent in another revision of the patch to rewrite
how GiST inserts work.

Shigeru HANADA sent in two more revisions of the core functionality
for FOREIGN DATA WRAPPER, part of the SQL/MED specification.

Marko (johto) Tiikkaja sent in a patch which allows advisory locks to
be released automatically when the transaction ends.

ITAGAKI Takahiro sent in a patch to export some functions from copy.c,
which will be useful for SQL/MED file operations, among other things.

Florian Pflug sent in another revision of the serializable lock
consistency patch. Heikki Linnakangas sent in some typo fixes for
same.

Florian Pflug sent in two revisions of a fix for the serializable lock
consistency patch.

Shigeru HANADA sent in another revision of the patch to implement a
file foreign data wrapper.

Shigeru HANADA sent in a patch to use the exported COPY functions in
the above file_fdw patch.

Heikki Linnakangas sent in another revision of the patch to fix the
GiST insert algorithm.

Alex Hunsaker sent in two revisions of a patch to fix an issue with
PL/PerlU's treatment of utf8.

ITAGAKI Takahiro sent in a patch to add pg_read_binary_file().

Dimitri Fontaine sent in three more revisions of the patch to add
extensions.

Magnus Hagander sent in a patch to allow libpq to check its version.

Peter Eisentraut sent in a patch to fix an issue with localtimestamp
inside certain queries.

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

Robert Haas sent in a patch to fix an issue with unlogged tables vs.
xlog.

Pavel Stehule sent in a patch to factor out some redundant code from
pl_exec.c.

Robert Haas sent in another revision of the patch to relax synchronous
commit behavior when no WAL is written.

Peter Eisentraut sent in a patch to allow casting a table's row type
to the table's supertype if it is a typed table.

Peter Eisentraut sent in a WIP patch which would switch psql from
normal to expanded and vice versa depending on the width of the
terminal window it's in.

Tomas Vondra sent in another revision of the patch to keep a timestamp
of the last stats reset by database, table and function.

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




--=20
Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein