Skip site navigation (1) Skip section navigation (2)

== Wöchentlicher PostgreSQL Newsletter - 28. September 2008 ==

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-de-allgemein(at)postgresql(dot)org <pgsql-de-allgemein(at)postgresql(dot)org>
Cc: pgusers(at)postgres(dot)de <pgusers(at)postgres(dot)de>
Subject: == Wöchentlicher PostgreSQL Newsletter - 28. September 2008 ==
Date: 2008-09-29 11:27:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein
Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 28. September 2008 ==

Eine lebhafte Diskussion über SE-PostgreSQL wird auf -hackers geführt.

Registrierung für PGDay.IT ist jetzt möglich.

ArcGIS 9.3 unterstützt jetzt PostgreSQL.

== PostgreSQL Produkt Neuigkeiten ==

check_postgres 2.2.1 erschienen.

MyJSQLView 2.91 erschienen.

PL/Proxy 2.0.7 erschienen.

== PostgreSQL Jobs im September ==

== PostgreSQL Lokal == wird am 4. Oktober in Toulouse. Der Call for Papers ist

Die Russische PostgreSQL Usergruppe wird sich am 6. Oktober in Moskau
treffen. Spezielle Gäste werden erwartet, unter anderem Gavin Roy von und Asko Oja und Marko Krenn von Skype.

Die Highload++ Konferenz wird vom 6.-8- Oktober in Moskau, Russland
statfinden. Gavin Roy, Asko Oja und Maxim Boguk sprechen über
PostgreSQL Dinge.

Die PostgreSQL West Konferenz 2008 wird vom 12. bis 12. Oktober in
Portland, State University in Portland, Oregon stattfinden.
Vorträge einzureichen unter:

Das Ohio LinuxFest 2008, welches am 11. Oktober in Columbus
stattfindet, wird dieses Jahr wieder einen PostgreSQL Stand haben.
Kontaktiere melanie AT dunslane DOT net um zu helfen.

Die PostgreSQL User Group Deutschland wird einen Talk und einen
Workshop auf dem Magdeburger Open Source Tag 2008 in Magdeburg,
Deutschland halten.

Der Europäische PostgreSQL Tag (PGDay 2008) findet am 17. und 18.
Oktober in Prato, Toskana, Italien statt. Die Registrierung ist offen:

PostgreSQL hat einen Stand auf der LinuxLive, Olymbia, in Londok (GB)
vom 23-25. Oktober 2008. Schreibe Dave Page wenn du teilnehmen möchtest.
dpage AT pgamin DOT org

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter Jean-Paul Argudo, Gabriele Bartolini, Nikolay Samokhvalov, and
Andreas (ads) Scherbaum.

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Tom Lane committed:

- Fix dblink_connect() so that it verifies that a password is supplied
  in the conninfo string *before* trying to connect to the remote
  server, not after.  As pointed out by Marko Kreen, in certain
  not-very-plausible situations this could result in sending a
  password from the postgres user's .pgpass file, or other places that
  non-superusers shouldn't have access to, to an untrustworthy remote
  server.  The cleanest fix seems to be to expose libpq's
  conninfo-string-parsing code so that dblink can check for a password
  option without duplicating the parsing logic.  Joe Conway, with a
  little cleanup by Tom Lane.

- Get rid of pgpass_from_client tracking inside libpq --- given the
  conclusion that presence of the password in the conninfo string must
  be checked *before* risking a connection attempt, there is no point
  in checking it afterwards.  This makes the specification of
  PQconnectionUsedPassword() a bit simpler and perhaps more generally
  useful, too.

- In pgsql/src/pl/plpgsql/src/pl_exec.c, fix unportable syntax used in
  recent patch.  Per results from buildfarm member 'bear'.

- In pgsql/src/backend/rewrite/rewriteHandler.c, fix more problems
  with rewriter failing to set Query.hasSubLinks when inserting a
  SubLink expression into a rule query.  We missed cases where the
  original query contained a sub-SELECT in a function in FROM, a
  multi-row VALUES list, or a RETURNING list.  Per bug #4434 from Dean
  Rasheed and subsequent investigation.  Back-patch to 8.1; older
  releases don't have the issue because they didn't try to be smart
  about setting hasSubLinks only when needed.

- Establish the rule that array types should have the same typdelim as
  their element types.  Since the backend doesn't actually pay
  attention to the array type's delimiter, this has no functional
  effect, but it seems better for the catalog entries to be
  consistent.  Per gripe from Greg Mullane and subsequent discussion.

- In pgsql/src/backend/utils/adt/like_match.c, make LIKE throw an
  error if the escape character is at the end of the pattern (ie, has
  nothing to quote), rather than silently ignoring the character as
  has been our historical behavior.  This is required by SQL spec and
  should help reduce the sort of user confusion seen in bug #4436.
  Per discussion.  This is not so much a bug fix as a definitional
  change, and it could break existing applications; so not
  back-patched.  It might deserve being mentioned as an
  incompatibility in the 8.4 release notes.

- In pgsql/src/backend/utils/adt/formatting.c, fix pointer-advancement
  bugs in MS and US cases of new to_timestamp() code.  Alex Hunsaker.

- Add hooks to let plugins override the planner's lookups in
  pg_statistic.  Simon Riggs, with some editorialization by me.

- In pgsql/src/backend/utils/adt/selfuncs.c, dept of second thoughts:
  let's make sure that get_index_stats_hook is only applied to
  expression indexes, not to plain relations.  The original coding in
  btcostestimate conflated the two cases, but it's not hard to use
  get_relation_stats_hook instead when we're looking to the underlying

Heikki Linnakangas committed:

- Make LC_COLLATE and LC_CTYPE database-level settings. Collation and
  ctype are now more like encoding, stored in new datcollate and
  datctype columns in pg_database.  This is a stripped-down version of
  Radek Strnad's patch, with further changes by me.

- Tighten the check in initdb and CREATE DATABASE that the chosen
  encoding matches the encoding of the locale. LC_COLLATE is now
  checked in addition to LC_CTYPE.

- In pgsql/src/bin/pg_dump/pg_dump.c, fix pg_dump bug in the
  database-level collation patch. "datcollate" and "datctype" columns
  were misspelled. Per report from Chris Browne.

Bruce Momjian committed:

- Mention battery-backed cache under hardware selection options.

- Add comment about the use of EXEC_BACKEND.

- In pgsql/doc/src/sgml/charset.sgml, fix markup tag error, envvar ->

- In pgsql/src/backend/utils/adt/datetime.c, fix integral timestamps
  so the output is consistent in all cases to round: select interval
  '0:0:0.7', interval '@ 0.70 secs', interval '0.7 seconds'; Ron

- In pgsql/doc/src/sgml/plpgsql.sgml, add documentation about when
  trigger values NEW/OLD return NULL.  Jeff Davis.

Magnus Hagander committed:

- In pgsql/src/backend/utils/misc/guc.c, only show source file and
  line numbers to superusers, for consistent security level with other
  parts of the system.  Per gripe from Tom.

- Make sure pg_control is opened in binary mode, to deal with
  situtations when the file contains an EOF maker (0x1A) on Windows.
  ITAGAKI Takahiro.

- In pgsql/src/bin/pg_resetxlog/pg_resetxlog.c, silence compiler
  warning caused by recent collation patch.

Andrew Dunstan committed:

- In pgsql/src/backend/utils/adt/like_match.c, compare escaped chars
  case insensitively for ILIKE - per gripe from TGL.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Gregory Stark sent in another patch to do prefetching for bitmap heap
scans and index scans, sets POSIX_FADV_SEQUENTIAL for bulk sequential
scans, and fixes autoconf tests for posix_fadvise.

Simon Riggs sent in two more revisions of his infrastructure changes
for recovery.

Andrew Dunstan sent in three WIP patches for parallel restore.

Heikki Linnakangas sent in doc changes for the FSM rewrite.

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

Heikki Linnakangas sent in two more revision of his FSM rewrite, this
time without WAL logging.

Tatsuo Ishii, Jeff Davis and Tom Lane sent in more work on the CTE

Benedek Laszlo sent in another revision of his patch to add roles to

Peter Eisentraut sent in another revision of his patch to fix some
issues in vpath builds.

		Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Andreas 'ads' ScherbaumDate: 2008-10-06 08:42:55
Subject: == Wöchentlicher PostgreSQL Newsletter - 05. Oktober 2008 ==
Previous:From: Andreas KretschmerDate: 2008-09-25 12:38:13
Subject: Re: Tabellenverbunde oder besser Views?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group