Skip to content

Wöchentlicher PostgreSQL Newsletter - 27. Juni 2010

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 27. Juni 2010 ==

PostgreSQL sucht nach Kommentaren über das 9.0 Release. Wenn du von
einem oder mehreren 9.0 Neuerungen begeistert bist und eine Firma, ein
NGO oder Behörden repräsentierst, sende uns bitte deinen Kommentar an

PGXN, das PostgreSQL Netzwerk für Erweiterungen, modelliert nach CPAN,
ist gestartet.

== PostgreSQL Produkt Neuigkeiten ==

Slony-I 2.0.4, eine eine kaskadierende Master-Slave
Replikationslösung für PostgreSQL, ist erschienen.

Benetl 3.5, ein ETL Werkzeug für Dateien, die PostgreSQL
nutzen, ist erschienen.

Muldis-D 0.130.0, eine Spezifikation für eine Objekt-relationale
Sprache, die auf PostgreSQL und anderen Systemen läuft, ist erschienen.

== PostgreSQL 9.0 Feature der Woche ==

== PostgreSQL Tipp der Woche ==

== PostgreSQL Jobs im Juni ==

== PostgreSQL Lokal ==

Für die CHAR(10), die PostgreSQL-Konferenz über Clustering,
Hochverfügbarkeit und Replikation kann man sich jetzt online
anmelden und buchen. Die Veranstaltung findet am 2. und 3. Juli 2010
im Oriel College an der Oxford Universität in England statt.

Der PDXPUG Day findet am 18. Juli 2010 im Oregon Convention
Center in Portland, OR., statt. Mehr Informationen unter:

OSCON wird in Portland, Oregon vom 19. bis 23. Juli 2010 stattfinden.

FrOSCon 2010 findet in St. Augustin, Deutschland am 21. und 22. August
2010 statt. Die Deutsche PostgreSQL Usergruppe hat ihren eigenen Devroom
und sucht noch Vorträge. Weitere Informationen unter:

== PostgreSQL in den News ==

Planet PostgreSQL:

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, deutsche an, italienische an

== Angewandte Patches ==

Heikki Linnakangas committed:

- In pgsql/src/pl/plpgsql/src/pl_exec.c, in a PL/pgSQL "FOR cursor"
  statement, the statements executed in the loop might close the
  cursor, rendering the Portal pointer to it invalid.  Closing the
  cursor in the middle of the loop is not a very sensible thing to do,
  but we must handle it gracefully and throw an error instead of

Robert Haas committed:

- Minor markup improvements for Hot Standby documentation.

- Deprecate the use of => as an operator name.  In HEAD, emit a
  warning when an operator named => is defined.  In both HEAD and the
  backbranches (except in 8.2, where contrib modules do not have
  documentation), document that hstore's text => text operator may be
  removed in a future release, and encourage the use of the
  hstore(text, text) function instead.  This function only exists in
  HEAD (previously, it was called tconvert), so backpatch it back to
  8.2, when hstore was added.  Per discussion.

- In pgsql/contrib/hstore/expected/hstore.out, updated expected-output
  file for hstore.  This is an oversight in my previous patch to
  deprecate => as an operator name.  Per buildfarm.

- Add TCP keepalive support to libpq.  This adds four additional
  connection parameters to libpq: keepalives, keepalives_idle,
  keepalives_count, and keepalives_interval.  keepalives default to
  on, per discussion, but can be turned off by specifying
  keepalives=0.  The remaining parameters, where supported, can be
  used to adjust how often keepalives are sent and how many can be
  lost before the connection is broken.  The immediate motivation for
  this patch is to make sure that walreceiver will eventually notice
  if the master reboots without closing the connection cleanly, but it
  should be helpful in other cases as well.  Tollef Fog Heen, Fujii
  Masao, and me.

- In pgsql/src/backend/postmaster/postmaster.c, add stray "else" that
  seems to have gone missing.

- In pgsql/doc/src/sgml/release-9.0.sgml, further 9.0 release notes
  updates.  Josh Berkus.

- In pgsql/doc/src/sgml/high-availability.sgml, some copy-editing of
  the Hot Standby documentation.  Thanks to Joshua Tolley for the

- In pgsql/doc/src/sgml/installation.sgml, make AIX suggestions about
  disabling ipv6 more version-sensitive.  Chris Browne, based on a
  report from John Pierce.

- In pgsql/doc/src/sgml/libpq.sgml, rewrite docs for new libpq
  keepalive parameters.  The revised documentation makes it more clear
  that these are client-side parameters, rather than server side
  parameters.  It also puts the main point of each parameter first,
  and consolidates the conditions under which it might be ignored in a
  single list at the end.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ref/pg_ctl-ref.sgml, update pg_ctl docs to
  explain server output behavior differences on win32 and non-win32

- Fix pg_upgrade's use of pg_ctl on Win32 to not send command and
  sever output to the same file, because it is impossible.  Also set
  user name for pg_dumpall in pg_upgrade.

- Add username designations to all pg_upgrade utility calls that
  support it.

- In pgsql/doc/src/sgml/ref/alter_table.sgml, mention that when alter
  rewrites a table, indexes are also rebuilt.

Simon Riggs committed:

- Fix log_temp_files docs and comments to say bytes not kilobytes.
  stat(2) field st_size returns bytes not kilobytes.  Bug found during
  recent performance tuning for PostgreSQL user.

Tom Lane committed:

- Fix thinko in tok_is_keyword(): it was looking at the wrong union
  variant of YYSTYPE, and hence returning the wrong answer for cases
  where a plpgsql "unreserved keyword" really does conflict with a
  variable name.  Obviously I didn't test this enough :-(.  Per bug
  #5524 from Peter Gagarinov.

- In pgsql/src/bin/pg_dump/pg_backup_custom.c, fix pg_restore so
  parallel restore doesn't fail when the input file doesn't contain
  data offsets (which it won't, if pg_dump thought its output wasn't
  seekable).  To do that, remove an unnecessarily aggressive error
  check, and instead fail if we get to the end of the archive without
  finding the desired data item.  Also improve the error message to be
  more specific about the cause of the problem.  Per discussion of
  recent report from Igor Neyman.  Back-patch to 8.4 where parallel
  restore was introduced.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Guillaume Lelarge sent in a patch to add a CHECK_FOR_INTERRUPTS call
to the copy_relation_data(), copy_dir(), and copy_file() functions,
which fixes an issue where cancelling ALTER TABLE ...  SET TABLESPACE

Heikki Linnakangas sent in a patch to fix an issue where the server
would crash while trying to read an expression using pg_get_expr().

Andrew Dunstan sent in a WIP patch to make ENUMs alterable.

Kevin Grittner sent in a cleaned-up version of the patch to allow
dividing money by money.

Peter Eisentraut sent in a patch to make PostgreSQL compile under

Peter Eisentraut sent in another revision of the patch which allows
ommission of non-aggregate columns in certain situations in GROUP BY.

Pavel Baros sent in a patch to implement materialized views.

Robert Haas sent in a patch to simplify emode_for_corrupt_record.

Mark Fowler sent in another revision of the patch to add an
xpath_exists function.

Mark Fowler sent in another revision of the patch to add XMLEXISTS to
the grammar.

Robert Haas sent in a patch to allow suppressing crash recovery after
a crash, per discussion on -performance about a volatile version of


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options