Skip to content

Wöchentlicher PostgreSQL Newsletter - 13. Juni 2010

Der Originalartikel befindet sich unter:

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

PostgreSQL 9.0 Beta 2 erschienen. Testen!

Neue Umfrage: Welches 9.0 Beta Feature (abgesehen von der Replikation)
ist dein Favorit?

Das Videoarchiv für das SFPUG Meeting vom 8. Dezember 2009, "Operator
Exclusion Constraints", ist jetzt verfügbar:

== PostgreSQL Produkt Neuigkeiten ==

pgnotifyd v0.1, ein asynchroner Notification Prozessor für
PostgreSQL, ist erschienen.

== PostgreSQL Jobs im Juni ==

== PostgreSQL Lokal ==

Michael Renner wird auf der Netways OSDC in Nürnberg, Deutschland,
am 23./24. Juni 2010 einen Vortrag halten.

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.

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

Teodor Sigaev committed:

- In pgsql/contrib/dblink/uninstall_dblink.sql, add missed function
  dblink_connect_u(text[,text]) to uninstall script

Tom Lane committed:

- In pgsql/src/backend/replication/walreceiver.c, avoid useless
  snprintf() call when update_process_title is turned off.  Fujii

- In pgsql/src/pl/plpython/plpython.c, fix quite-bogus handling of
  arrays in plpython datum-to-PyObject conversion.  Per bug #5497 from
  David Gardner.

- In pgsql/src/bin/scripts/vacuumdb.c, add missing 'Z' letter to
  getopt_long call --- the newly added --analyze-only switch did not
  work in its short form -Z.  Josh Berkus

- In pgsql/doc/src/sgml/Makefile, Postgres.txt should get cleaned by
  'make clean'.

Robert Haas committed:

- In pgsql/doc/src/sgml/plhandler.sgml, make procedural language
  handler reference C-language function docs.  Based on suggestions
  from Jonathan Leto and Joshua Tolley.

- In pgsql/src/backend/commands/explain.c, attempt to fix EXPLAIN
  (FORMAT YAML) quoting to behave sanely.  The previous code failed to
  quote in many cases where quoting was necessary - YAML has loads of
  special characters, including -:[]{},"'|*& - so quote much more
  aggressively, and only refrain from quoting things where it seems
  fairly clear that it isn't necessary.  Per report from Dean Rasheed.

- In pgsql/src/backend/catalog/pg_largeobject.c, remove stray word
  from comment.

- In pgsql/src/backend/commands/explain.c, quote all string values in
  EXPLAIN (FORMAT YAML) output.  While my previous attempt seems to
  always produce valid YAML, it doesn't always produce YAML that means
  what it appears to mean, because of tokens like "0xa" and "true",
  which without quotes will be interpreted as integer or Boolean
  literals.  So, instead, just quote everything that's not known to be
  a number, as we do for JSON.  Dean Rasheed, with some changes to the
  comments by me.

  The previous coding failed for OIDs too large to be represented by a
  signed integer.

- In pgsql/doc/src/sgml/release-9.0.sgml, fix typo.

- In pgsql/doc/src/sgml/release-9.0.sgml, fix misplaced modifier.  As
  suggested by Ian Barwick.

Tatsuo Ishii committed:

- In pgsql/src/backend/replication/walreceiver.c, fix typo in the
  header comment.  Per request from Masao Fujii.

ITAGAKI Takahiro committed:

- In pgsql/contrib/dblink/dblink.c, fix connection leak in dblink when
  dblink_connect() or dblink_connect_u() end with "duplicate
  connection name" errors.  Backported to release 7.4.

- In pgsql/contrib/dblink/dblink.c, avoid "identifier will be
  truncated" warning in dblink when connection string is longer than
  NAMEDATALEN.  The previous fix for long connection name broke the

- In pgsql/contrib/dblink/dblink.c, fix incorrect change in dblink
  introduced by the previous commit "Fix connection leak in dblink".

- Rename restartpoint_command to archive_cleanup_command.

- In pgsql/src/backend/storage/ipc/standby.c, remove max_standby_delay
  message from ps display of recovery process in waiting status. The
  parameter is not so interesting in ps display because it is
  referable in postgresql.conf.

Magnus Hagander committed:

- In pgsql/src/backend/access/transam/xlog.c, make the walwriter close
  its handle to an old xlog segment if it's no longer the current one.
  Not doing this would leave the walwriter with a handle to a deleted
  file if there was nothing for it to do for a long period of time,
  preventing the file from  being completely removed.  Reported by
  Tollef Fog Heen, and thanks to Heikki for some hand-holding with the

Heikki Linnakangas committed:

- In standby mode, respect checkpoint_segments in addition to
  checkpoint_timeout to trigger restartpoints.  We used to
  deliberately only do time-based restartpoints, because if
  checkpoint_segments is small we would spend time doing restartpoints
  more often than really necessary.  But now that restartpoints are
  done in bgwriter, they're not as disruptive as they used to be.
  Secondly, because streaming replication stores the streamed WAL
  files in pg_xlog, we want to clean it up more often to avoid running
  out of disk space when checkpoint_timeout is large and
  checkpoint_segments small.  Patch by Fujii Masao, with some minor
  changes by me.

- Return NULL instead of 0/0 in pg_last_xlog_receive_location() and
  pg_last_xlog_replay_location().  Per Robert Haas's suggestion, after
  Itagaki Takahiro pointed out an issue in the docs.  Also, some
  wording changes in the docs by me.

- Make TriggerFile variable static.  It's not used outside xlog.c.
  Fujii Masao.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/syntax.sgml, add index entry for ::, per
  complaint from John Gage.

- In pgsql/doc/src/sgml/ref/alter_table.sgml, update ALTER TABLE docs
  to account for exclusion and deferrable uniqueness constraints.
  Dean Rasheed.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/release-9.0.sgml, update text of 9.0 release
  notes.  Josh Berkus.

- In pgsql/doc/src/sgml/Makefile, add space between after ">" in ">$@"
  in SGML Makefile, for clarity.

- In pgsql/doc/src/sgml/Makefile, add SGML Makefile rule for
  single-page text, postgres.txt.

- Have pg_upgrade create its output files in the current directory,
  rather than in a subdirectory of the $HOME directory, or $TMP in

- In pgsql/doc/src/sgml/Makefile, remove lynx -stdin flag for

- In pgsql/src/test/regress/pg_regress.c, add missing --use-existing
  --help mention from regression binary.  Jan Urbanski

- In pgsql/contrib/pg_upgrade/pg_upgrade.h, update pg_upgrade C
  comment about cwd.

Peter Eisentraut committed:

- Add a regression test case for bug #5497.

- In pgsql/src/pl/plpython/expected/README, update Python version

- In pgsql/src/backend/access/transam/xlog.c, fix typo/bug, found by
  Clang compiler.

- Add target to build HTML documentation as single page.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Fujii Masao sent in a patch per Andrew Dunstan to clarify that to use
a pgpass file to connect to Streaming Replica standbys, it is
necessary to use a * for the database field.

Peter Eisentraut sent in a WIP patch to allow GROUP BY to infer
functional dependencies and not require that the target list include
all non-aggregated columns when it finds them, per the SQL standard.

Alexander Korotkov sent in another revision of the patch to allow
multi-byte character sets in Levenshtein functions in the supplied
module for fuzzy string matching.

Joel Jacobson sent in another revision of the patch to add
a pg_stat_transaction system view.

Robert Haas sent in a patch to deprecate => and add ==> to the hstore
module, per discussion.


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