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

== Wöchentlicher PostgreSQL Newsletter - 05. September 2010 ==

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 - 05. September 2010 ==
Date: 2010-09-06 11:00:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 05. September 2010 ==

== PostgreSQL Produkt Neuigkeiten ==

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

== PostgreSQL Jobs im September ==

== PostgreSQL Lokal ==

Der Call for Papers für den PGDay.EU 2010 am 6.-8. Dezember in
Stuttgart ist nun eröffnet.

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fetter.

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

Heikki Linnakangas committed:

- In pgsql/src/backend/storage/ipc/procsignal.c, fix typo in comment.

Simon Riggs committed:

- In pgsql/src/backend/storage/ipc/procarray.c, teach GetOldestXmin()
   about KnownAssignedXids during recovery.  Very minor issue, though
   this is required for a later patch.  Reported by Heikki Linnakangas.

- In pgsql/src/backend/access/transam/xlog.c, truncate subtrans after
   each restartpoint.  Issue reported by Harald Kolb, patch by Fujii
   Masao, review by me.

- In pgsql/src/backend/access/transam/xlog.c, fix misleading DEBUG2
   issued during RemoveOldXlogFiles().

Tom Lane committed:

- In pgsql/src/backend/access/transam/xlogutils.c, fix oversight in
   RelFileNodeBackend patch: CreateFakeRelcacheEntry needs to
   initialize the rd_backend field of a fake Relation entry correctly.
   Fortunately, that is easy, since only non-temp relations should ever
   be mentioned in the WAL stream.

- In pgsql/src/backend/storage/ipc/procarray.c, cosmetic fixes for
   KnownAssignedXidsGetOldestXmin, per Fujii Masao.

- In pgsql/src/include/port/solaris.h, back-port into 8.2 an old fix
   to ensure that BYTE_ORDER gets set correctly on 64-bit Intel
   Solaris.  Per my proposal yesterday, 8.2 is where we will start
   considering this platform supported.  While this patch itself could
   easily go into older branches, there's not a huge amount of point
   unless we also make some significantly-more-invasive changes in the
   spinlock support.

- In pgsql/doc/src/sgml/release-9.0.sgml, improve release notes'
   description of Teodor Sigaev's fixes for polygon overlaps and
   contains operators.

- Clarify documentation of handling of null arguments for aggregates.
   Per discussion.

- Fix up flushing of composite-type typcache entries to be driven
   directly by SI invalidation events, rather than indirectly through
   the relcache.  In the previous coding, we had to flush a
   composite-type typcache entry whenever we discarded the
   corresponding relcache entry.  This caused problems at least when
   testing with RELCACHE_FORCE_RELEASE, as shown in recent report from
   Jeff Davis, and might result in real-world problems given the kind
   of unexpected relcache flush that that test mechanism is intended to
   model.  The new coding decouples relcache and typcache management,
   which is a good thing anyway from a structural perspective.  The
   cost is that we have to search the typcache linearly to find entries
   that need to be flushed.  There are a couple of ways we could avoid
   that, but at the moment it's not clear it's worth any extra trouble,
   because the typcache contains very few entries in typical operation.
   Back-patch to 8.2, the same as some other recent fixes in this
   general area.  The patch could be carried back to 8.0 with some
   additional work, but given that it's only hypothetical whether we're
   fixing any problem observable in the field, it doesn't seem worth
   the work now.

- In pgsql/doc/src/sgml/ecpg.sgml, clean up some bad grammar and
   punctuation in description of ecpg's decimal type.  Per KOIZUMI

- In pgsql/doc/src/sgml/ecpg.sgml, clean up description of ecpg's
   dtcvfmtasc function.  Per KOIZUMI Satoru.

- 9.1alpha1 release notes.

- In HEAD only, revert kluge solution for preventing misuse of
   pg_get_expr().  A data-type-based solution, which is much cleaner
   and more bulletproof, will follow shortly.  It seemed best to make
   this a separate commit though.

- Install a data-type-based solution for protecting pg_get_expr().
   Since the code underlying pg_get_expr() is not secure against
   malformed input, and can't practically be made so, we need to
   prevent miscreants from feeding arbitrary data to it.  We can do
   this securely by declaring pg_get_expr() to take a new datatype
   "pg_node_tree" and declaring the system catalog columns that hold
   nodeToString output to be of that type.  There is no way at SQL
   level to create a non-null value of type pg_node_tree.  Since the
   backend-internal operations that fill those catalog columns operate
   below the SQL level, they are oblivious to the datatype relabeling
   and don't need any changes.

- In pgsql/src/backend/utils/misc/ps_status.c, pad the ps_status
   display with nulls, not blanks, on Darwin.  A long time ago, this
   didn't work nicely, but it seems to work on all recent versions of
   OS X.  The blank-pad method is less desirable since it results in
   lots of extra space in ps' output.  Per Alexey Klyukin.

- In pgsql/src/backend/catalog/pg_constraint.c, GROUP BY can only
   infer functional dependency from non-deferrable primary keys.
   Peter's original patch had this right, but I dropped the check while
   revising the code to search pg_constraint instead of pg_index.
   Spotted by Dean Rasheed.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/ref/create_aggregate.sgml, add missing markup
   for translatability.

Robert Haas committed:

- In pgsql/src/backend/catalog/objectaddress.c, fix typo.  Pointed out
   by Kevin Grittner.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Marko (johto) Tiikkaja sent in a patch to make all query list snapshot
handling work like EXPLAIN ANALYZE's code does.  Apart from cleanup,
this is infrastructure for writeable CTEs.

Heikki Linnakangas sent in two more revisions of the "latch" patch,
now with Windows support.

KaiGai Kohei sent in another revision of the patch to add security
label support.

ITAGAKI Takahiro sent in a patch to improve CLUSTER and CLUSTER
VERBOSE.  It is intended to be applied atop

KaiGai Kohei sent in two more revisions of the patch to plug leaky

Suchant Sinha sent in two revisions of a patch to support multiple
words in the same position in text search.

Pavel Stehule sent in another WIP patch to add "format" functions.

Pavel Stehule sent in another WIP patch to (de)serialize the
textsearch ISpell dictionary.

Hans-Juergen Schoenig sent in another revision of the patch to push
sorts into partitions.

Bruce Momjian sent in three revisions of a patch to force
pg_controldata into English.

KaiGai Kohei sent in a patch to allow external security providers to
check privileges to create a new relation and to inform the security
labels to be assigned on the new one.

Hans-Juergen Schoenig sent in an revision of the patch to do
merge-append, updated to 9.1-to-be.

Heikki Linnakangas sent in a WIP patch to allow streaming a base
backup from a master.

Kevin Grittner sent in a patch correcting usages of "serializable" in
the code.

			Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Thomas UzunoffDate: 2010-09-08 08:39:15
Subject: PostgreSQL Artikel online - PDF
Previous:From: Andreas 'ads' ScherbaumDate: 2010-08-30 20:45:54
Subject: == Wöchentlicher PostgreSQL Newsletter - 29. August 2010 ==

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