Skip to content

Wöchentlicher PostgreSQL Newsletter - 06. Dezember 2009

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 06. Dezember 2009 ==

Das aktuelle Commitfest endet bald. Reviewe jetzt die Patches der
anderen, damit du frisch an deinen eigenen Starten kannst :)

PostgreSQL hat jetzt offizielle Release-Regeln. Details unter:

Neue Umfrage: Wie trägst du zu PostgreSQL bei?

Jeff Davis präsentiert Operator Exclusion Constraints auf der SFPUG am
Dienstag, dem 8. Dezember in San Francisco.

Das nächste AustinPUG Treffen findet am Mittwoch, dem 9. Dezember 2009
statt. Jim Nasby wird über Tabellenvererbung sprechen.

Das erste Treffen der New York Capital District PUGs findet am 7.
Januar 2010 statt.

PGDay-Kuba 2010 wird vom 4.-6. Februar 2010 in La Havana an der
Universität für wissenschaftliche Informatik stattfinden. Teilnehmer
von Kuba, der Dominikanischen Republik und Venezuela sind eingeladen.

== PostgreSQL Produkt Neuigkeiten ==

COBOL-IT Precompiler für PostgreSQL ist erschienen.,cntnt01,detail,0&cntnt01articleid=31&cntnt01detailtemplate=simple&cntnt01returnid=58

GT portalBase 2.4, ein Framework für PostgreSQL, ist erschienen.

PostgreSQL Maestro 9.12, ein GUI zum Administrieren und für die
Entwicklung unter Windows, ist erschienen.

MicroOLAP Database Designer 1.2.9 für PostgreSQL ist erschienen.

PgCon 2010 findet vom 20.-21. Mai 2010 in Ottawa statt mit Tutorials
vorher am 18. und 19. Der Call for Papers ist offen!

pgpool-II 2.2.6, ein Connection Pooler und mehr,
ist erschienen.

PostgreDAC 2.5.4 beta, ein Delphi/C++ Builder für PostgreSQL, ist

Quick Application Suite und Quick Application Builder sind erschienen.

== PostgreSQL Jobs im Dezember ==

== PostgreSQL Lokal ==

Stefan Keller gibt einen Kurs "Einführung in PostGIS/PostgreSQL" an
der HSR Hochschule für Technik Rapperswil (HSR) am 14. Januar 2010
in Zürich, Schweiz.

FOSDEM 2010 findet am 6. und 7. Februar 2010 in Brüssel,
Belgien statt.

Die Chemnitzer Linuxtage finden am 13. und 14. März in
Chemnitz, Deutschland statt.

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

== Reviews ==

- Josh Tolley reviewed the PL/Python array support patch and sent a
  patch atop it to fix regression tests.

- Jeff Davis reviewed Joachim Wieland's Listen/Notify patch and
  requested further rework from the author.

- Andrew (RhodiumToad) Gierth reviewed Hitoshi Harada's patch to
  improve window frame control with ROWS BETWEEN.  To complete the
  review, he will need a decision on the API for aggregate functions.

- Hitoshi Harada marked Andrew (RhodiumToad) Gierth's patch, "ready
  for committer."

- Simon Riggs did a preliminary review of ITAGAKI Takahiro's
  partitioning syntax patch.

- ITAGAKI Takahiro reviewed Greg Smith's patch to enable resetting

== Applied Patches ==

Bruce Momjian committed:

- In pgsql/doc/src/sgml/ecpg.sgml, properly indent SGML.

- There is no reference to THREAD_SUPPORT outside configure, and it is
  never set, so remove it.

- In pgsql/doc/src/sgml/hstore.sgml, update hstore docs, mostly
  word-smithing.  David E. Wheeler

- Add ProcessUtility_hook() to handle all DDL to
contrib/pg_stat_statements. Itagaki Takahiro.

- Revert due to Tom's concerns: Add ProcessUtility_hook() to handle
  all DDL to contrib/pg_stat_statements.

- Adjust 'psql -f -' to behave like a normal file and honor the -1
  flag.  Report from Robert Haas.

- Enable thread safety on all platforms.  This will either be followed
  up by a more extensive patch, or reverted, depending on the build
  farm results.

- Apply full patch to enable thread-safety by default, e.g. doc

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/xfunc.sgml, in SRF example, move oldcontext
  variable definition into the FIRSTCALL branch, which is how most
  actual code is actually structured.  Also fix slight whitespace

- In pgsql/doc/src/sgml/information_schema.sgml, add a sentence of
  documentation about the differences between the *_privileges and the
  role_*_grants views.

- Speed up information schema privilege views.  Instead of expensive
  cross joins to resolve the ACL, add table-returning function
  aclexplode() that expands the ACL into a useful form, and join
  against that.  Also, implement the role_*_grants views as a thin
  layer over the respective *_privileges views instead of essentially
  repeating the same code twice.  Fixes bug #4596.  By Joachim
  Wieland, with cleanup by me.

Tom Lane committed:

- In pgsql/src/backend/tsearch/dict_thesaurus.c, avoid core dump on
  empty thesaurus dictionary.  Per report from Robert Gravsjo.

- Teach the regular expression functions to do case-insensitive
  matching and locale-dependent character classification properly when
  the database encoding is UTF8.  The previous coding worked okay in
  single-byte encodings, or in any case for ASCII characters, but
  failed entirely on multibyte characters.  The fix assumes that the
  <wctype.h> functions use Unicode code points as the wchar
  representation for Unicode, ie, wchar matches pg_wchar.  This is
  only a partial solution, since we're still stupid about non-ASCII
  characters in multibyte encodings other than UTF8.  The practical
  effect of that is limited, however, since those cases are generally
  Far Eastern glyphs for which concepts like case-folding don't apply
  anyway.  Certainly all or nearly all of the field reports of
  problems have been about UTF8.  A more general solution would
  require switching to the platform's wchar representation for all
  regex operations; which is possible but would have substantial
  disadvantages.  Let's try this and see if it's sufficient in

- Instead of sending application_name as a SET command after the
  connection is made, include it in the startup-packet options.  This
  makes it work more like every other libpq connection option, in
  particular it now has the same response to RESET ALL as the rest.
  This also saves one network round trip for new applications using
  application_name.  The cost is that if the server is pre-8.5, it'll
  reject the startup packet altogether, forcing us to retry the entire
  connection cycle.  But on balance we shouldn't be optimizing that
  case in preference to the behavior with a new server, especially
  when doing so creates visible behavioral oddities.  Per discussion.

- Mark application_name as GUC_REPORT so that the value will be
  reported back to the client by the server.  This might seem pretty
  pointless but apparently it will help pgbouncer, and perhaps other
  connection poolers.  Anyway it's practically free to do so for the
  normal use-case where appname is only set in the startup packet ---
  we're just adding a few more bytes to the initial ParameterStatus
  response packet.  Per comments from Marko Kreen.

- In pgsql/src/backend/postmaster/postmaster.c, ignore attempts to set
  "application_name" in the connection startup packet.  This avoids a
  useless connection retry and complaint in the postmaster log when
  receiving a connection from 8.5 or later libpq.  Backpatch in all
  supported branches, but of course not HEAD.

- In pgsql/doc/src/sgml/ref/rollback_to.sgml, clarify what's supposed
  to happen when a cursor FETCH is rolled back by aborting a
  subtransaction.  Per discussion with Heikki.

- In pgsql/src/include/catalog/pg_proc.h, don't use a duplicate OID
  for aclexplode().

Teodor Sigaev committed:

- in contrib/btree_gist, prevent intersection of ranges during page
  split.  Changes are only optimization, so don't backpatch.

Heikki Linnakangas committed:

- Fix bug in temporary file management with subtransactions.  A cursor
  opened in a subtransaction stays open even if the subtransaction is
  aborted, so any temporary files related to it must stay alive as
  well.  With the patch, we use ResourceOwners to track open temporary
  files and don't automatically close them at subtransaction end
  (though in the normal case temporary files are registered with the
  subtransaction resource owner and will therefore be closed).  At end
  of top transaction, we still check that there's no temporary files
  marked as close-at-end-of-transaction open, but that's now just a
  debugging cross-check as the resource owner cleanup should've closed
  them already.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

ITAGAKI Takahiro sent in another revision of the YAML output patch for

ITAGAKI Takahiro sent in another revision of the VACUUM FULL patch per
review from Jeff Davis.  Jeff Davis sent three patches atop that one.

Andrew (RhodiumToad) Gierth sent in another revision of the patch to
add ORDER BY to aggregates.

KaiGai Kohei sent in another revision of the SE-PostgreSQL patch.

ITAGAKI Takahiro sent in a patch to modify the result type of
pg_read_file to bytea.

Bruce Momjian sent in two revisions of a patch to enable thread safety
in client libraries by default.

Zdenek Kotala sent in another revision of a patch to correct the
Docbook path in Solaris.

Tsutomu Yamada sent in two revisions of a patch to support Windows 64.

Caleb Welton sent in two revisions of a patch to fix int2vectorin.

Jeff Davis sent in another revision of the operator exclusion
constraints patch per review from Robert Haas.

Michael Paquier sent in two more revisions of the patch to add shell
calls to pgbench, per review from Greg Smith.

ITAGAKI Takahiro sent in another revision of the ProcessUtility_hook
patch per feedback from Tom Lane.

Bruce Momjian sent in a patch to install PL/pgsql by default.

Tim Bunce sent in a patch to refactor PL/Perl, and a patch atop that
to add some new GUCs with promising names including
plperl.on_perl_init, plperl.on_trusted_init, and
plperl.on_untrusted_init, along with some bug fixes and general code
correctness improvements.

KaiGai Kohei sent in another revision of the ACL patch for large

ITAGAKI Takahiro sent in another revision of the SQL syntax patch for

Zdenek Kotala sent in another revision of the patch to enable pg_ctl
to do an initdb.

Hitoshi Harada sent in another revision of the ROWS functionality for
windowing per review from Andrew (RhodiumToad) Gierth.

Jeff Davis sent in another revision of the VACUUM FULL removal patch.

Greg Smith sent in a patch to enable resetting statistics.

Simon Riggs sent in a patch to fix an issue with running out of lock
space in certain hot standby scenarios.


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