Der Originalartikel befindet sich unter:
http://www.postgresql.org/community/weeklynews/pwn20090524
=3D=3D W=C3=B6chentlicher PostgreSQL Newsletter - 24. Mai 2009 =3D=3D
PostgreSQL 8.1 Beta 2 erschienen. Testen!
http://www.postgresql.org/developer/beta
PgCon war ein gro=C3=9Fer Erfolg, mit einer gesteigerten Besucherzahl im
Angesicht von wenigern Besuchern auf anderen Konferenzen. Das Video
zur Konferenz erscheint demn=C3=A4chst.
http://www.pgcon.org/2009/
Das Video vom SFPUG Treffen am 12. Mai 2009, "BIRT & PostgreSQL", ist
jetzt zum Anschauen und Herunterladen auf media.postgresql.org
verf=C3=BCgbar.
http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov
Die 10. j=C3=A4hrliche JPUG Konferenz hat den Call for Proposals gestartet.
http://archives.postgresql.org/pgsql-announce/2009-05/msg000 18.php
MicroOLAP Database Designer 1.2.8 Beta1, ein Windows-basierender
Designer f=C3=BCr PostgreSQL, ist erschienen.
http://microolap.com/products/database/postgresql-designer/
Die PostgreSQL/PostGIS Community wird sich am 6. Juni 2009 in Z=C3=BCrich
treffen. Details (in de_CH) unter:
http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-H=C3=B6ck
=3D=3D PostgreSQL Produkt Neuigkeiten =3D=3D
=3D=3D PostgreSQL 8.4 Feature der Woche =3D=3D
Warm Standby: Wenn dich das Aufsetzen eines Warm Standby Servers vorher
verwirrt hat, dann gib 8.4 eine Chance; das ist viel
benutzerfreundlicher.
=3D=3D PostgreSQL Tipp der Woche =3D=3D
Bis in 8.4 die Common Table Expressions und in 8.5 das SQL/MED
erscheint, kannst du das "tablefunc" Contrib Modul nutzen, um mittels
connect_by() Joins und Anfragen zwischen verschiedenen Datenbanken
oder der gleichen Datenbank zu nutzen.
=3D=3D PostgreSQL Jobs im Mai =3D=3D
http://archives.postgresql.org/pgsql-jobs/2009-05/threads.ph p
=3D=3D PostgreSQL Lokal =3D=3D
PGDay Junin / Buenos Aires Unnoba wird am 6. Juni 2009 stattfinden.
http://www.arpug.com.ar/trac/wiki/PgDayUnnoba
Termin vormerken: pgDay San Jose, am Sonntag dem 19. Juli unmittelbar
vor der OSCON. CfP und mehr Informationen bald.
PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.
PGDay.EU 2009 wird an der Telecom ParisTech Universit=C3=A4t in Paris,
Frankreich, am 6. und 7. Nivember 2009 stattfinden.
http://www.pgday.eu/
=3D=3D PostgreSQL in den News =3D=3D
Planet PostgreSQL: http://planet.postgresql.org/
Dieser w=C3=B6chentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Josh Berkus.
Sende Neuigkeiten und Ank=C3=BCndigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beitr=C3=A4ge an david [at] fetter.org, deutsche an
pwn [at] pgug.de, italienische an pwn [at] itpug.org.
=3D=3D Angewandte Patches =3D=3D
Peter Eisentraut committed:
- Some documentation cleanup for the addition of the KOI8U encoding.
Change all (remaining) mentions of KOI8 to the new canonical form
KOI8R. Add information about the available conversions for KOI8U.
- Refer to tables by id, not by "the following table", because tables
are in theory floating elements.
- In pgsql/src/backend/catalog/sql_features.txt, update SQL
conformance entries for window functions functionality
- In pgsql/src/tools/editors/emacs.samples, add some instructions on
how to customize emacs for working on the SGML sources.
- Add documentation string for LDFLAGS_SL in configure --help output.
- In pgsql/src/tools/editors/emacs.samples, fix sgml-mode example.
Thanks, Andrew Dunstan.
- In pgsql/src/bin/pg_dump/pg_dump.c, convert some messages to use
ngettext(). Author: Euler Taveira de Oliveira.
Tom Lane committed:
- In pgsql/src/interfaces/libpq/fe-connect.c, make pwdfMatchesString()
a little more careful about matching * fields.
- Fix bug #4814 (wrong subscript in consistent-function call), and add
some minimal regression test coverage for matchPartialInPendingList().
- Fix LIKE's special-case code for % followed by _. I'm not entirely
sure that this case is worth a special code path, but a special code
path that gets the boundary condition wrong is definitely no good.
Per bug #4821 from Andrew Gierth. In passing, clean up some minor
code formatting issues (excess parentheses and blank lines in odd
places). Back-patch to 8.3, where the bug was introduced.
- Use more-portable coding for the check on handing out the last
available relopt_kind value in add_reloption_kind(). Per Zdenek
Kotala.
Heikki Linnakangas committed:
- In pgsql/src/backend/commands/analyze.c, update relpages and
reltuples estimates in stand-alone ANALYZE, even if there's no
analyzable attributes or indexes. We also used to report 0 live and
dead tuples for such tables, which messed with autovacuum threshold
calculations. This fixes bug #4812 reported by George Su. Backpatch
back to 8.1.
- In pgsql/src/backend/commands/tablecmds.c, silence a gcc compiler
warning about non-literal format string with no args when compiling
with -Wformat-security. Fujii Masao.
Michael Meskes committed:
- Removed some unneeded variables and comparisons.
- More variables gcc moans about.
- Removed unsigned/signed mismatches.
- Removed comparison of unsigned expression < 0.
Teodor Sigaev committed:
- In pgsql/src/backend/utils/adt/tsvector.c, re-sort tsvector's
lexemes in tsvectorrecv instead of emitting an error. Basically,
it's needed to support binary dump from 8.3 because the ordering
rule was changed. Per discussion with Bruce Momjian.
=3D=3D Abgelehnte Patches (bis jetzt) =3D=3D
No one was disappointed this week :-)
=3D=3D Eingesandte Patches =3D=3D
Simon Riggs sent in two patches to improve read-only scalability.
Pavel Stehule sent in another revision of the GROUPING SETS patch.
Jim Nasby sent in a patch to add a feature to vacuumdb that allows
analyze-only as an option.
Robert Haas sent in a patch to add parenthesized options to EXPLAIN.
Pavel Stehule sent in a patch to clean up some syntax warnings in
tsquery_op.c
Zdenek Kotala sent in two patches to do some cleanup to help
pg_migrator.
Tatsuhito Kasahara sent in a patch to fix ja.po.
Steve Prentice sent in two versions of a patch to supplement Pavel
Stehule's patch for named and mixed notation support in 8.5. Pavel
sent in a followup that touches the main parser. Steve sent an
updated patch.
Dimitri Fontaine sent in a document patch for GiST extensions.
Adriano Lange sent in a patch implementing 2PO, an alternative to
the GEQO for optimizing large joins.
Andres Freund sent in a patch to allow EXPLAIN ANALYZE to show
counts of discarded tuples.
--
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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein
