Skip to content

Wöchentlicher PostgreSQL Newsletter - 11. Oktober 2009

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 11. Oktober 2009 ==

Das aktuelle Commitfest endet diese Woche, danach kommt recht bald
Alpha2. Fertigmachen zum Testen!

Josh Berkus präsentiert: die mächtigen GUCS der SFPUG in San Francisco
am 13. Oktober um 19 Uhr Pazifischer Zeit. Details zum Webcast ect

Federico Campoli wird einen PostgreSQL Vortrag auf der GULP (Linuxtag
Pisa) am 24. Oktober 2009 halten. Informationen auf italienisch unter:

== PostgreSQL Produkt Neuigkeiten ==

PGLogAnalysis 0.5, ein Log Analysierer für PostgreSQL, ist erschienen.

Oleg Bartunov hat ein neues Contrib Modul für PostgreSQL erstellt:

PostgreDAC ver. 2.5.3, ein Delphi/C++ Builder für PostgreSQL, ist

Prefix 1.0.0, ein Modul für schnelle Prefix Suchen, ist erschienen.

Mark Kirkwood hat einen großen Performance Bug in PDO_pgsql, ein PHP
Modul um PostgreSQL Datenbanken anzusprechen, gefixt.

== PostgreSQL Jobs im Oktober ==

== PostgreSQL Lokal ==

Es findet eine Konferenz in Seattle, Washington, USA am 16.-18.
Oktober 2009 statt.

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden. Registrierung offen:

Federico Campoli wird einen PostgreSQL Vortrag auf der GULP (Linuxtag
Pisa) am 24. Oktober 2009 halten. Informationen auf italienisch unter:

PGDay.EU 2009 wird an der Telecom ParisTech Universität in Paris,
Frankreich, am 6. und 7. November 2009 stattfinden.

OpenSQL Camp in Portland sucht Sponsoren. Bereite deine Reisepläne
jetzt vor! :)

Die 10. jährliche JPUG Konferenz findet am 20-21. November 2009 in
Tokio, Japan, statt.

FOSDEM 2010 wird am 6./7. Februar 2010 in Brüssel stattfinden.

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

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an, deutsche an, italienische an

== Angewandte Patches ==

Tom Lane committed:

- Create an ALTER DEFAULT PRIVILEGES command, which allows users to
  adjust the privileges that will be applied to subsequently-created
  objects.  Such adjustments are always per owning role, and can be
  restricted to objects created in particular schemas too.  A notable
  benefit is that users can override the traditional default privilege
  settings, eg, the PUBLIC EXECUTE privilege traditionally granted by
  default for functions.  Petr (PJMODOS) Jelinek.

- Change CREATE TABLE so that column default expressions coming from
  different inheritance parent tables are compared using equal(),
  instead of doing strcmp() on the nodeToString representation.  The
  old implementation was always a tad cheesy, and it finally fails
  completely as of 8.4, now that the node tree might contain syntax
  location information.  equal() knows it's supposed to ignore those
  fields, but strcmp() hardly can.  Per recent report from Scott Ribe.

- Support use of function argument names to identify which actual
  arguments match which function parameters.  The syntax uses AS, for
  example funcname(value AS arg1, anothervalue AS arg2).  Pavel

- Update plhandler.sgml to describe validators and inline handlers for
  procedural languages.

- Remove very ancient tuple-counting infrastructure (IncrRetrieved()
  and friends).  This code has all been ifdef'd out for many years,
  and doesn't seem to have any prospect of becoming any more useful in
  the future.  EXPLAIN ANALYZE is what people use in practice, and I
  think if we did want process-wide counters we'd be more likely to
  put in dtrace events for that than try to resurrect this code.  Get
  rid of it so as to have one less detail to worry about while
  refactoring execMain.c.

- Split the processing of INSERT/UPDATE/DELETE operations out of
  execMain.c.  They are now handled by a new plan node type called
  ModifyTable, which is placed at the top of the plan tree.  In itself
  this change doesn't do much, except perhaps make the handling of
  RETURNING lists and inherited UPDATEs a tad less klugy.  But it is
  necessary preparation for the intended extension of allowing
  RETURNING queries inside WITH.  Marko (johto) Tiikkaja.

- Improve similar_escape() in two different ways: 1. Stop escaping ?
  and {.  As of SQL:2008, SIMILAR TO is defined to have
  POSIX-compatible interpretation of ? as well as {m,n} and related
  constructs, so we should allow these things through to our regex
  engine.  2.  Escape ^ and $.  It appears that our regex engine will
  treat ^^ at the beginning of the string the same as ^, and similarly
  for $$ at the end of the string, which meant that SIMILAR TO was
  effectively ignoring ^ at the start of the pattern and $ at the end.
  Since these are not supposed to be metacharacters, this is a bug.
  The second part of this is arguably a back-patchable bug fix, but
  I'm hesitant to do that because it might break applications that are
  expecting something like "col SIMILAR TO '^foo$'" to work like a
  POSIX pattern.  Seems safer to only change it at a major version
  boundary.  Per discussion of an example from Doug Gorley.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/Makefile, unbreak doc/src/sgml
  maintainer-clean rule on VPATH builds.

- In pgsql/doc/src/sgml/Makefile, really unbreak maintainer-clean.
  (Or rather, unbreak what the previous commit broke)

- Fix snapshot management, take two.  Partially revert the previous
  patch I installed and replace it with a more general fix: any time a
  snapshot is pushed as Active, we need to ensure that it will not be
  modified in the future.  This means that if the same snapshot is
  used as CurrentSnapshot, it needs to be copied separately.  This
  affects serializable transactions only, because CurrentSnapshot has
  already been copied by RegisterSnapshot and so PushActiveSnapshot
  does not think it needs another copy.  However,
  CommandCounterIncrement would modify CurrentSnapshot, whereas
  ActiveSnapshots must not have their command counters incremented.  I
  say "partially" because the regression test I added for the previous
  bug has been kept.  (This restores 8.3 behavior, because before
  snapmgr.c existed, any snapshot set as Active was copied.) Per bug
  report from Stuart Bishop.

- Make it possibly to specify GUC params per user and per database.
  Create a new catalog pg_db_role_setting where they are now stored,
  and better encapsulate the code that deals with settings into its
  realm.  The old datconfig and rolconfig columns are removed.  psql
  has gained a \drds command to display the settings.  Backwards
  compatibility warning: while the backwards-compatible system views
  still have the config columns, they no longer completely represent
  the configuration for a user or database.  Catalog version bumped.

- Add the new psql command \drds to the psql docs, help and tab
  completion.  I also thank Bernd Helmle for the documentation help on
  the previous settings patch, which I forgot on the commit message.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/Makefile, clean up the clean rules of the
  documentation.  Most things should be cleaned by "make clean",
  except the parts that are shipped in the tarball.  These rules had
  gotten a bit out of whack after the various restructurings of the
  documentation build rules.

- Use pg_get_triggerdef in pg_dump.  Add a variant of
  pg_get_triggerdef with a second argument "pretty" that causes the
  output to be formatted in the way pg_dump used to do.  Use this
  variant in pg_dump with server versions >= 8.5.  This insulates
  pg_dump from most future trigger feature additions, such as the
  upcoming column triggers patch.  Itagaki Takahiro.

Heikki Linnakangas committed:

- Fix off-by-one bug in bitncmp(): When comparing a number of bits
  divisible by 8, bitncmp() may dereference a pointer one byte out of
  bounds.  Chris Mikkelson (bug 5101).

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

ITAGAKI Takahiro sent in another revision of the buffer usage patch
for EXPLAIN and pg_stat_statements.

Zoltan Boszormenyi sent in another revision of the SQLDA patch for

Martin Pihlak sent in a patch to fix a regression test breakage in
foreign data wrappers when a system user exists with the same name.

Andrew (RhodiumToad) Gierth sent in a WIP patch to add ORDER BY to
array_agg() per SQL:2008.

Emmanuel Cecchet sent in another revision of the COPY enhancement

Roger Leigh sent in four more revisions of the patch to do Unicode
pretty-printing in psql.

KaiGai Kohei sent in two more revisions of the patch for large object
access controls.

Andreas 'ads' Scherbaum sent in another revision of the patch to add

Simon Riggs sent in another revision of the Hot Standby patch.

ITAGAKI Takahiro sent in another revision of the patch to fix the
console and eventlog issues on Win32.

Simon Riggs sent in a patch to add more "if (InHotStandby)" tests to
Hot Standby.

Simon Riggs sent in a patch to fix a subtransaction issue in Hot

Zoltan Boszormenyi sent in two more revisions of the SQLDA patch for
ECPG along with a doc patch intended to go with.

Laurenz Albe sent in patches to add a hook which allows checking
cryptographic strength of passwords, a module which uses the hook and
documentation for the module.

Petr (PJMODOS) Jelinek sent in another revsion of the GRANT ON ALL IN
SCHEMA patch.


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