Skip to content

Wöchentlicher PostgreSQL Newsletter - 08. Februar 2009

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 08. Februar 2009 ==

PostgreSQL 8.3.6, 8.2.12, 8.1.16, 8.0.20 und 7.4.24 erschienen.
Jetzt upgraden!

Der 2. Call for Papers für die PostgreSQL Conference East endet am 23.
Februar 2009.

Wenn du Mappen für die LAPUG Pizza Party am Freitag den 20. Februar im
Westin in Los Angeles üllen möchtest, schreibe an lapug AT postgresql
DOT org um zu helfen.

== PostgreSQL Produkt Neuigkeiten ==

pgpool-II 2.2 beta2 erschienen.

== PostgreSQL Tipp der Woche ==

Bis 8.4 mit einer sehr effizienten eingebauten array_accum() Funktion
herauskommt, kannst du selbige Funktion aus der PostgreSQL Dokumentation
addieren und damit alle Spalten in ein Array zusammenfügen. Dies kann in
Applikationen genutzt werden oder zusammen mit array_to_string() um eine
Liste zu erstellen:

== PostgreSQL Jobs im Februar ==

== PostgreSQL Lokal ==

JNBPUG trifft sich am 9. Februar um 19:00 Uhr im News Cafe in der
New Road in Midrand.

Stephen Frost wird über Column-Level Permissions bei der BWPUG sprechen,
am 9. Februar um 18:30 Uhr in den OmniTI Büros.

Der Prager PostgreSQL Entwicklertag 2009 findet am 12. Februar statt.

Die Bulgarische PostgreSQL User Gruppe trifft sich am 12. Februar 2009
um 19 Uhr im Vinarnata, 19 Lavele str., Sofia.

SFPUG präsentiert: Reece Hart von Unison DB für rechenbetonte Biologie
am 10. Februar 2009, der Ort wird noch bekannt gegeben.

PostgreSQL wird auf der SCALE vom 20. bis 22. Februar in Los Angeles
vertreten sein.

Andreas 'ads' Scherbaum wird einen Vortrag auf dem Perl Workshop 2009
am 25. Februar in Frankfurt am Main, Deutschland, halten.

PostgreSQL Conference U.S. wird einen PgDay auf dem Linuxfest Nordwest
am 25. und 26. April veranstalten. Der Call for Papers ist unter:

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, 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 ==

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/catalogs.sgml, put pg_user_mapping section
  into the right (alphabetical) order.

- In pgsql/src/backend/catalog/sql_features.txt, set column privileges
  to supported.

Michael Meskes committed:

- Fixed bug in ecpg's %s handling.

- Fixed auto allocation for binary data types in ecpg.

- In pgsql/src/interfaces/ecpg/test/sql/binary.pgc, set memory segment
  to '0', just to be sure.

- In ecpg, when changing a regression test file one should also change
  the expected output file.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, fixed copy&paste
  mistake that made library use uninitialized variable.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, argh, wrong line
  copied again.

- In ecpg, added result checks for calls to gmtime().

- In pgsql/src/interfaces/ecpg/pgtypeslib/dt_common.c, mixing long and
  int entries of a union only works on some architectures.

Alvaro Herrera committed:

- Allow reloption names to have qualifiers, initially supporting a
  TOAST qualifier, and add support for this in pg_dump.  This allows
  TOAST tables to have user-defined fillfactor, and will also enable
  us to move the autovacuum parameters to reloptions without taking
  away the possibility of setting values for TOAST tables.

- Fix some SGML-compiler warnings on -wxml mode.

Andrew Dunstan committed:

- Provide for parallel restoration from a custom format archive. Each
  data and post-data step is run in a separate worker child (a thread
  on Windows, a child process elsewhere) up to the concurrent number
  specified by the new pg_restore command-line --multi-thread | -m
  switch.  Andrew Dunstan, with some editing by Tom Lane.

- Allow alternative names for tclsh used on Windows.

Tom Lane committed:

- In pgsql/src/pl/plpgsql/src/gram.y, fix plpgsql to not treat INSERT
  INTO as an INTO-variables clause anywhere in the string, not just at
  the start.  Per bug #4629 from Martin Blazek.  Back-patch to 8.2;
  prior versions don't have the problem, at least not in the reported
  case, because they don't try to recognize INTO in non-SELECT
  statements.  (IOW, this is really fallout from the RETURNING patch.)

- In pgsql/doc/src/sgml/ref/select.sgml, document the longstanding
  behavior of LIMIT NULL and OFFSET NULL, per gripe from David Wheeler
  that this was mentioned nowhere.  In passing, editorialize a bit on
  the description of the SQL:2008 equivalent syntax.

- In pgsql/src/backend/postmaster/syslogger.c, add a failure check for
  syslogger's use of _beginthreadex(), and remove unnecessary thread
  address output parameter, to make this code look more like that in

- In pgsql/src/backend/optimizer/path/joinpath.c, fix an old
  corner-case error in match_unsorted_outer(): don't consider the
  cheapest-total inner path as a new candidate while truncating the
  sort key list, if it already matched the full sort key list.  This
  is too much of a corner case to be worth back-patching, since it's
  unusual for the cheapest total path to be sorted, and anyway no real
  harm is done (except in JOIN_SEMI/ANTI cases where cost_mergejoin is
  a bit broken at the moment).  But it wasn't behaving as intended, so
  fix it.  Noted while examining a test case from Kevin Grittner.
  This error doesn't explain his issue, but it does explain why "set
  enable_seqscan = off" seemed to reproduce it for me.

- Clean up some loose ends from the column privileges patch: add
  has_column_privilege and has_any_column_privilege SQL functions; fix
  the information_schema views that are supposed to pay attention to
  column privileges; adjust pg_stats to show stats for any column you
  have select privilege on; and fix COPY to allow copying a subset of
  columns if the user has suitable per-column privileges for all the
  columns.  To improve efficiency of some of the information_schema
  views, extend the has_xxx_privilege functions to allow inquiring
  about the OR of a set of privileges in just one call.  This is just
  exposing capability that already existed in the underlying aclcheck
  routines.  In passing, make the information_schema views report the
  owner's own privileges as being grantable, since Postgres assumes
  this even when the grant option bit is not set in the ACL.  This is
  a longstanding oversight.  Also, make the new has_xxx_privilege
  functions for foreign data objects follow the same coding
  conventions used by the older ones.  Stephen Frost and Tom Lane

- In pgsql/doc/src/sgml/ref/copy.sgml, ooops, forgot to update COPY
  reference page to mention column privileges.

- Fix cost_mergejoin's failure to adjust for rescanning of non-unique
  merge join keys when considering a semi or anti join.  This requires
  estimating the selectivity of the merge qual as though it were a
  regular inner join condition.  To allow caching both that and the
  real outer-join-aware selectivity, split RestrictInfo.this_selec
  into two fields.  This fixes one of the problems reported by Kevin

- In pgsql/src/backend/executor/execMain.c, ensure that INSERT ...
  SELECT into a table with OIDs never copies row OIDs from the source
  table.  This could never happen anyway before 8.4 because the
  executor invariably applied a "junk filter" to rows due to be
  inserted; but now that we skip doing that when it's not necessary,
  the case can occur.  Problem noted 2008-11-27 by KaiGai Kohei,
  though I misunderstood what he was on about at the time (the opacity
  of the patch he proposed didn't help).

Bruce Momjian committed:

- In pgsql/doc/src/sgml/mvcc.sgml, update read committed documentation
  to better explain undesirable behavior of concurrent commands in
  cases where rows are being added and removed from matching query
  criteria.  Minor word-smithing.

  statement.  Pavel Stehule.

- In pgsql/doc/src/sgml/libpq.sgml, document ways to avoid libpq
  WSACleanup() overhead on Windows.  Andrew Chernow.

- In pgsql/doc/src/sgml/libpq.sgml, fix typo in docs.

- Fix to_timestamp() to not require upper/lower case matching for
  meridian designations (AM/PM).  Also separate out matching of a
  meridian with periods (e.g. A.M.) and with those without.  Do the
  same for AD/BC.  Brendan Jurd

- Document disabling the statistics collector pg_dump activity, and
  give a bit more visibility to the PGOPTIONS environment variable
  supported by libpq.  Bryce Nesbitt

- In pgsql/doc/src/sgml/catalogs.sgml, update pg_constraint.conkey
  documentation description.

- In pgsql/doc/src/sgml/ref/pg_dump.sgml, properly wrap new pg_dump
  doc text.

- In pgsql/src/interfaces/ecpg/ecpglib/Makefile, ecpg requires libpq;
  add Makefile rules to require libpq to be built first.  Alvaro

- In pgsql/doc/src/sgml/catalogs.sgml, uppercase CHECK mention in
  relchecks documentation mention.

- In pgsql/doc/src/sgml/indices.sgml, remove documentation mention
  that hash indexes perform no better than btree;  keep mention about
  missing WAL logging.  Kenneth Marshall

- In pgsql/doc/src/sgml/queries.sgml, document that LIMIT NULL is the
  same as no LIMIT clause.  Report by David Wheeler.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/xlog.c, fix obsolete comment.
  Zdenek Kotala.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Fernando Ike de Oliveira sent in another revision of his patch to add
\dL (show languages) to psql.

David Wheeler sent in a doc patch to explicate that LIMIT NULL returns
all rows.

Zdenek Kotala sent in a fix for Czech (cs_CZ) locale regression tests.

Stephen Frost sent in another revision of his column-level privileges

Teodor Sigaev sent in another revision of his GIN improvements patch.

KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.

Alvaro Herrera sent in another revision of the reloptions patch to
remove autovacuum parameters.

Peter Eisentraut sent in a patch to add basic KOI8-U support.

Alvaro Herrera sent in a doc patch for the reloptions patch.

David Lee Lambert sent in a patch which lets Linux use the ext2fs UUID
generator for UUIDs.

Tom Lane sent in a patch to make ALTER TABLE SET WITH OIDS actually
add the aforementioned OIDs.


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