Skip to content

Wöchentlicher PostgreSQL Newsletter - 18. Januar 2009

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 18. Januar 2009 ==

== PostgreSQL Tipp der Woche ==

Um die Queries nur einer Datenbank zu loggen, nutze:
    ALTER <datenbankname> SET log_statement = 'all'

== PostgreSQL Jobs im Januar ==

== PostgreSQL Lokal ==

Richard Broersma koordiniert die Standhelfer für SCALE (siehe unten).
Kontaktiere ihn unter richard DOT broersma AT gmail DOT com.

Die Moskauer PostgreSQL und MySQL Gruppen organisieren am 22. Januar
2009 eine gemeinsame Versammlung in Moskau. Details und Anmeldungen:

SYDPUG wird sich am 3. Februar 2009 um 18:30 Uhr bei Fujitsu
Australia in Nord Sydney treffen. Mark Leslie wird über die Geschichte
und Motivationen von PostGIS sprechen.

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

Viele der üblichen Verdächtigen werden auf der FOSDEM am 7. und 8.
Februar in Brüssel, Belgien sein.

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:

- Add ONLY support to LOCK and TRUNCATE.  By default, these commands
  are now recursive.  Note this incompatibility in the release notes.

- In pgsql/src/backend/parser/gram.y, use qualified_name instead of
  relation_expr for commands that have no business with inheritance
  They would just silently ignore the ONLY.  ALTER TABLE has mixed
  behavior and cannot be dealt with this way because of the resulting
  shift/reduce conflicts.

- In pgsql/doc/src/sgml/ref/select.sgml, add some minimal
  documentation that the SQL standard requires parentheses after ONLY.

- In pgsql/src/tools/make_etags, remove useless (and insecure) temp
  file handling.

- In pgsql/src/interfaces/ecpg/ecpglib/Makefile, misc.o depends on
  pg_config_paths.h when --enable-nls is used.

- In pgsql/src/pl/tcl/pltcl.c, make error messages match backend

- In pgsql/src/backend/catalog/information_schema.sql, make the
  columns is_insertable_into and is_updatable behave uniformly
  correctly.  They are supposed to examine which kinds of rules are
  present, which they did in some of the info schema views but not in

- In pgsql/src/tools/make_etags, avoid version-control system
  directories when creating TAGS.  Besides being wasteful, this can
  collide with repostory metadata on case-insensitive file sytems.

- In pgsql/src/, make .pot files depend on the makefiles,
  so that they are updated when the file or trigger function lists are

- In pgsql/src/interfaces/ecpg/test/Makefile, build needed things in
  src/test/regress/ first.  And some build rules normalization.

- NLS cleanup in ecpglib Replace leftover instances of _() by
  ecpg_gettext(), the latter being the correct way to refer to the
  library's message catalog, instead of the one of the program using
  the library.  Drop NLS support for ecpg_log(), which is a debugging
  instrument similar to elog() in the backend.  We cannot support NLS
  in the ecpg compatlib, because that requires ecpg_gettext, which is
  in ecpglib, which is not a dependency of compatlib.  It doesn't seem
  worthwhile to worry about this, since the only translatable string
  is "out of memory", and gettext probably won't be able to do much
  without memory either.  Adjust messages to project style.

- In pgsql/src/pl/tcl/, remove unneeded GETTEXT_TRIGGERS.

- Cleanup pass over PL/Python NLS.  Add translation support to
  PLy_elog and PLy_exception_set, and clarify some error messages.

- In pgsql/src/bin/pg_ctl/pg_ctl.c, remove period from primary error

- Wordsmithing in pgsql/src/interfaces/ecpg/ecpglib/error.c.

- plpython_error.out is for Python 2.4, plpython_error_3.out is for
  Python 2.5, as it was previously.

- In pgsql/src/pl/plpython/expected/plpython_error_1.out, manual
  attempt to update this file.

Tom Lane committed:

- In pgsql/src/backend/executor/nodeBitmapHeapscan.c, tweak order of
  operations in BitmapHeapNext() to avoid the case of prefetching the
  same page we are nanoseconds away from reading for real.  There
  should be something left to do on the current page before we
  consider issuing a prefetch.

- Fix a pg_dump output ordering problem introduced in 8.3 by the
  addition of array types for composite types.  Although pg_dump
  understood it wasn't supposed to dump these array types as separate
  objects, it must include them in the dependency ordering analysis,
  and it was improperly assigning them the same relatively-high sort
  priority as regular types.  This resulted in effectively moving
  composite types and tables up to that same high priority, which
  broke any ordering requirements that weren't explicitly enforced by
  dependencies.  In particular user-defined operator classes, which
  should come out before tables, failed to do so.  Per report from
  Brendan Jurd.  In passing, also fix an ill-considered decision to
  give text search objects the same sort priority as functions and
  operators --- the sort result looks a lot nicer if different object
  types are kept separate.  The recent foreign-data patch had copied
  that decision, making the sort ordering even messier :-(

Alvaro Herrera committed:

- Simplify the writing of amoptions routines by introducing a
  convenience fillRelOptions routine that stores the parsed values in
  the struct using a table-based approach.  Per Tom suggestion.  Also
  remove the "continue" in HANDLE_*_RELOPTION macros, which were
  useless and in spirit they were assuming too much of how the macros
  were going to be used.  (Note that these macros are now unused, but
  the intention is to introduce some usage in a future autovacuum
  patch, which is why they weren't completely removed.) Also, do not
  call the string validation routine when not validating.  It seems
  less error-prone this way, per commentary on the amoptions SGML

- Backpatch to 7.4 the part of 1.84 (from the 8.0 timeline) that
  wasn't already patched, viz. str_numth().  The rest of that patch
  was already applied as part of  Per report and patch from
  Andreas 'ads' Scherbaum.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/backup.sgml, document how pglesslog can be
  used to reduce the storage requirements of PITR.

- Renable threading build for Solaris 2.5, per report from Andrew

- Check nsl library for gethostbyname_r() on all platforms (HP-UX uses
  it too).

- In pgsql/src/port/thread.c, remove empty #ifdef block.

- Make 'find' syntax consistent;  add .git exclusion to make_ctags.

- In pgsql/doc/src/sgml/wal.sgml, add documentation mention that full
  page writes have to be enabled for full pages to be restored during
  recovery.  Per private report from Michael Renner

- In pgsql/, modify distdir rule to skip .git directory.

Magnus Hagander committed:

- In pgsql/src/interfaces/libpq/fe-auth.c, remove special-handling of
  usernames with Kerberos authentication.  We will now always use the
  system username as the default, and not try to pick it up from the
  kerberos ticket.  This fixes the spurious error messages that show
  up on kerberos-enabled builds when not actually using kerberos, and
  puts it in line with how other authentication methods work.

- In pgsql/src/bin/pg_dump/pg_backup_archiver.c, throw an error when
  using -C and -1 at the same time in pg_restore.  It's not possible
  to do CREATE DATABASE inside a transaction, so previously we just
  got a server error instead.  Backpatch to 8.2, which is where the -1
  feature appeared.

Heikki Linnakangas committed:

- In pgsql/src/pl/plpgsql/src/pl_exec.c, remove broken Assertions that
  failed if a statement executed in PL/pgSQL is rewritten into another
  kind of statement, for example if an INSERT is rewritten into an
  UPDATE.  Back-patch to 8.3 and 8.2.  For HEAD, Tom suggested
  inventing a new SPI_OK_REWRITTEN return code, but that's not a
  backportable solution.  I'll do that as a separate patch, this patch
  will do as a stopgap measure for HEAD too in the meanwhile.

- In pgsql/doc/src/sgml/func.sgml, change explanation of
  pg_switch_xlog()'s return value to match code.

- Add vacuum_freeze_table_age GUC option, to control when VACUUM
  should ignore the visibility map and scan the whole table, to
  advance relfrozenxid.

Teodor Sigaev committed:

- In pgsql/src/backend/tsearch/wparser_def.c, fix generation too long
  headline with ShortWords.  Per

- Fix URL generation in headline. Only tag lexeme will be replaced by
  space.  Per

- In pgsql/contrib/tsearch2/expected/tsearch2.out, sync output of
  tsearch2 regression test.

- In pgsql/contrib/tsearch2/rank.c, fix uninitialized variables in

Neil Conway committed:

- In pgsql/doc/src/sgml/ref/create_user_mapping.sgml, fix typo.

- In pgsql/doc/src/sgml/ref/create_server.sgml, fix an ungrammatical

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Koichi Suzuki sent in another revision of the PITR improvement patch.

Bernd Helmle sent in another revision of his patch to make VIEWs

Magnus Hagander sent in a patch which improves the error and message
when the incompatible options -1 and -c are called together.

KaiGai Kohei sent in a WIP patch to fix some edge cases in the
column-level privileges patch.

KaiGai Kohei sent in five more revisions of his SE-PostgreSQL patches.

Alvaro Herrera sent in two revisions of a patch which adds namespaces
to reloptions.

Robert Haas sent in a patch which helps fix log rotation.

Fujii Masao sent in another revision of his synchronous replication

KaiGai Kohei sent in a patch which puts invocations of
markColumnForSelectPriv() in transformJoinUsingClause() to mark those
columns used.

Stephen Frost sent in four more revisions of his column-level
privileges patch.

Ramon Lawrence and Bryce Cutt sent in another revision of the patch to
improve the performance of multi-batchhash join for skewed data sets.

Simon Riggs sent in three more revisions of the hot standby patch.

Alvaro Herrera sent in a patch to move a tablespace.c call from smgr.c
into the new storage.c.

Teodor Sigaev sent in another revision of the patch to add B-Tree
emulation to GIN.

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

Peter Eisentraut sent in an update to Bernd Helmle's patch for
updateable views.

Alan Li sent in a patch which fixes some compiler warnings in gcc


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