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

== Wöchentlicher PostgreSQL Newsletter - 17. Oktober 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 - 17. Oktober 2010 ==
Date: 2010-10-19 14:35:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-de-allgemein

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 17. Oktober 2010 ==

== PostgreSQL Produkt Neuigkeiten ==

psqlODBC 09.00.0101, ein ODBC Treiber für PostgreSQL, ist erschienen.

== PostgreSQL Jobs im Oktober ==

== PostgreSQL Lokal ==

SFPUG präsentiert David Fetter und Josh Berkus über PL/Parrot, 9.0 Q&A
und JDCon West, oh mei!. Am 19. Oktober 2010 im EzRez in San Francisco.

PDXPUG präsentiert Aurynn Shaw über Postgres und Node.js. Am Dienstag,
dem 21. Oktober 2010, um 19:00-21:00 im FreeGeek in Portland, Oregon.

Die Deadline für den CfP für die MySQL Conf ist der 25. Oktober 2010.
Maile Selena Deckelmann selenamarie <AT> gmail <DOT> com für Feedback,
Hilfe bei EInreichungen oder um Ideen zu finden.

PgDay.IT 2010 wird am 10. Dezember in Rom stattfinden. Der Call for
Papers ist jetzt offen.

Frühbucherregistrierung für JDCon West 2010 ist jetzt möglich. Scott
McNealy, früher bei Sun Microsystems, wird die Keynote halten.

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)

== Reviews ==

Andrew Geery reviewed the patch to extend NOT NULL representation to

Alvaro Herrera reviewed the patch to fix snapshot taking inaccuracies.

== Angewandte Patches ==

Tom Lane pushed:

- Fix assorted bugs in GIN's WAL replay logic.  The original coding
   was quite sloppy about handling the case where XLogReadBuffer fails
   (because the page has since been deleted).  This would result in
   either "bad buffer id: 0" or an Assert failure during replay, if
   indeed the page were no longer there.  In a couple of places it also
   neglected to check whether the change had already been applied,
   which would probably result in corrupted index contents.  I believe
   that bug #5703 is an instance of the first problem.  These issues
   could show up without replication, but only if you were unfortunate
   enough to crash between modification of a GIN index and the next
   checkpoint.  Back-patch to 8.2, which is as far back as GIN has WAL

- Fix plpython so that it again honors typmod while assigning to tuple
   fields.  This was broken in 9.0 while improving plpython's
   conversion behavior for bytea and boolean.  Per bug report from

- Remove some unnecessary tests of pgstat_track_counts.  We may as
   well make pgstat_count_heap_scan() and related macros just count
   whenever rel->pgstat_info isn't null.  Testing pgstat_track_counts
   buys nothing at all in the normal case where that flag is ON; and
   when it's OFF, the pgstat_info link will be null, so it's still a
   useless test.  This change is unlikely to buy any noticeable
   performance improvement, but a cycle shaved is a cycle earned; and
   my investigations earlier today convinced me that we're down to the
   point where individual instructions in the inner execution loops are
   starting to matter.;a=commitdiff;h=f4d242ef94730c447d87b9840a40b0ec3371fe0f

- Document the DISTINCT noise word in the UNION/INTERSECT/EXCEPT
   constructs.  I also rearranged the order of the sections to match
   the logical order of processing steps: the distinct-elimination
   implied by SELECT DISTINCT happens before, not after, any
   UNION/INTERSECT/EXCEPT combination.  Per a suggestion from Hitoshi

- Allow WITH clauses to be attached to INSERT, UPDATE, DELETE
   statements.  This is not the hoped-for facility of using
   INSERT/UPDATE/DELETE inside a WITH, but rather the other way around.
   It seems useful in its own right anyway.  Note: catversion bumped
   because, although the contents of stored rules might look
   compatible, there's actually a subtle semantic change.  A single
   Query containing a WITH and INSERT...VALUES now represents writing
   the WITH before the INSERT, not before the VALUES.  While it's not
   clear that that matters to anyone, it seems like a good idea to have
   it cited in the git history for catversion.h.  Original patch by
   Marko Tiikkaja, with updating and cleanup by Hitoshi Harada.;a=commitdiff;h=07f1264dda0e776a7e329b091c127059bce8cc54

- Fix recent changes to not break non-IPV6-aware systems.;a=commitdiff;h=9771125c18c5746be57a55cfc31340f5311fca2c

- Improve GIN indexscan cost estimation.  The better estimate requires
   more statistics than we previously stored: in particular, counts of
   "entry" versus "data" pages within the index, as well as knowledge
   of the number of distinct key values.  We collect this information
   during initial index build and update it during VACUUM, storing the
   info in new fields on the index metapage.  No initdb is required
   because these fields will read as zeroes in a pre-existing index,
   and the new gincostestimate code is coded to behave (reasonably)
   sanely if they are zeroes.  Teodor Sigaev, reviewed by Jan Urbanski,
   Tom Lane, and Itagaki Takahiro.;a=commitdiff;h=48c7d9f6ff99714495b7d6d2ebc44fbbe992cc8f

- Fix a passel of inappropriately-named global functions in GIN.  The
   GIN code has absolutely no business exporting GIN-specific functions
   with names as generic as compareItemPointers() or newScanKey();
   that's just trouble waiting to happen.  I got annoyed about this
   again just now and decided to fix it.  This commit ensures that all
   global symbols defined in access/gin/ have names including "gin" or
   "Gin".  There were a couple of cases, like names involving
   "PostingItem", where arguably the names were already sufficiently
   nongeneric; but I figured as long as I was risking creating merge
   problems for unapplied GIN patches I might as well impose a uniform
   policy.  I didn't touch any static symbol names.  There might be
   some places where it'd be appropriate to rename some static
   functions to match siblings that are exported, but I'll leave that
   for another time.;a=commitdiff;h=419d2374bfbc1eae562121fde31c1aa0e8a164cb

Alvaro Herrera pushed:

- Fix typo.;a=commitdiff;h=82659e0456f5c5a52a35ee41e63882c280ec2496

- Allow pg_ctl to register the service in either AUTO or DEMAND start
   type Author: Quan Zongliang.  Documentation updates by David Fetter;a=commitdiff;h=0c9b166db5329119b6553e0f38fe486521f1352f

- Document that translate() removes characters in "from" that don't
   have a corresponding "to" character.  Author: Josh Kupershmidt.;a=commitdiff;h=33ae03f4003adb27651d00688016d1c4a979686f

ITAGAKI Takahiro pushed:

- Accept 'public' as a pseudo-role name in has_table_privilege() and
   friends to see if a particular privilege has been granted to PUBLIC.
   The issue was reported by Jim Nasby.  Patch by Alvaro Herrera, and
   reviewed by KaiGai Kohei.;a=commitdiff;h=d0f876ca8ccb7dc8820302543b114014b7bac090

Peter Eisentraut pushed:

- Mention the default pg_ctl wait time in the -t option documentation;a=commitdiff;h=ceb5b787c6fcfbb8667f3b0254d2f2796cee20e2

- Fix makefile logic to not break the build when xgettext is missing.
   xgettext is only required when make init-po is run manually; it is
   not required for a build.  The intent to handle that was already
   there, but the ifdef's were in the wrong place.;a=commitdiff;h=30e749dece0e6502d4dd0a3b2892eab61f8c073b

- Remove reference.ced.  This is a parsed DocBook DTD for the PSGML
   Emacs mode, but it hasn't been updated since we switched to DocBook
   4.2 about seven years ago.  Also, PSGML has deprecated this method
   of DTD parsing.;a=commitdiff;h=402e11913fe05a7523828554cc2de3f1eb982d9c

- Document (compositeval).* field selection syntax.;a=commitdiff;h=80ada4c0dbc877d494f7c8886fdaebda0fbbe0bc

- Complete the documentation of the USAGE privilege for foreign
   servers.  The GRANT reference page failed to mention that the USAGE
   privilege allows modifying associated user mappings, although this
   was already documented on the CREATE/ALTER/DROP USER MAPPING pages.;a=commitdiff;h=9f2d7f6e2de23ecc1cfdd4172e23bd8b949fbcd2

- Support MergeAppend plans, to allow sorted output from append
   relations.  This patch eliminates the former need to sort the output
   of an Append scan when an ordered scan of an inheritance tree is
   wanted.  This should be particularly useful for fast-start cases
   such as queries with LIMIT.  Original patch by Greg Stark, with
   further hacking by Hans-Jurgen Schonig, Robert Haas, and Tom Lane.

- Change references to SQL/XML:2003 to :2008 and renumber sections

- Support host names in pg_hba.conf.  Peter Eisentraut, reviewed by
   KaiGai Kohei and Tom Lane;a=commitdiff;h=6ab42ae36713b1e6f961c37e22f99d3e6267523b

   - Remove executable permission from files where it doesn't belong;a=commitdiff;h=1a996d6c2972b343d8ec446d1c7c4c5fa8e19ef4

- Put per-letter quicklinks at the top of the HTML bookindex page.;a=commitdiff;h=3bf79839c81b84a234c40faa56c8e0464a533b6a

- Add index entries for pg_stat* views.;a=commitdiff;h=e8a47b3cb92de64e80ae444e90f5a9cbb4294d48

- Make title capitalization consistent with surroundings;a=commitdiff;h=ef204db5778f04225dcf145f6480402a614fff73

Michael Meskes pushed:

- Applied patch by Itagaki Takahiro to fix incorrect status
   calculation in ecpglib. Instead of parsing the statement just as ask
   the database server. This patch removes the whole client side track
   keeping of the current transaction status.;a=commitdiff;h=816b008eaf1a1ff1069f3bafff363a9a8bf04a21

Simon Riggs pushed:

- Fix bug in comment of timeline history file.  Fujii Masao.;a=commitdiff;h=45cd9199c2498b04cccc3989a5abbd04def806b3

- Make startup process respond to signals to cancel waiting on latch.
   A tidy up for recently committed changes to startup latch.  Fujii

- Improvements to docs about pg_archive_cleanup and use of archives
   Brendan Jurd.;a=commitdiff;h=7085891784784fda7314c0510da901fc8402380a

- Correct WAL space calculation formula in docs.  Error pointed out by
   Fujii Masao, though not his patch.;a=commitdiff;h=915116bc62db2aaec7001bde6610128f4cbd29f9

Robert Haas pushed:

- Add pg_user_mappings to the table of system views.;a=commitdiff;h=e4682133586c641096969ff26dc520d1d6bac7cc

Bruce Momjian pushed:

- Improve comment about ignoring 128 error code on Windows: "Microsoft
   reports it is related to mutex failure:";a=commitdiff;h=23177114c6f4f12d313d453e9153daf80c94c70b

Magnus Hagander pushed:

- Fix low-risk potential denial of service against RADIUS login.
   Corrupt RADIUS responses were treated as errors and not ignored
   (which the RFC2865 states they should be). This meant that a user
   with unfiltered access to the network of the PostgreSQL or RADIUS
   server could send a spoofed RADIUS response to the PostgreSQL server
   causing it to reject a valid login, provided the attacker could also
   guess (or brute-force) the correct port number.  Fix is to simply
   retry the receive in a loop until the timeout has expired or a valid
   (signed by the correct RADIUS server) packet arrives.  Reported by
   Alan DeKok in bug #5687.;a=commitdiff;h=0e7f7071e893bb171150e53271404b0819a40669

- Fix msvc build for localized versions of Visual C++.  Look only at
   the non-localized part of the output from "vcbuild /?", which is
   used to determine the version of Visual Studio in use.  Different
   languages seem to localize different amounts of the string, but we
   assume the part "Microsoft Visual C++" won't be modified.;a=commitdiff;h=cd0e8253216907982fe369b91f6d788d699b6c47

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

KaiGai Kohei sent in another patch to fix some access control leaks in

Robert Haas sent in another revision of the levenshtein_less_equal

Dimitri Fontaine sent in a patch to implement CREATE EXTENSION.

Andrew Dunstan sent in another revision of the patch to make enums

Radoslaw Smogura sent in three more revisions of the patch to add
setQueryTimeout et al. to the JDBC driver.

Pursuant to Andrew Geery's review, Bernd Helmle and Dean Rasheed
traded new patches which extend NOT NULL representation into

Dean Rasheed reviewed and sent a revised patch for extensible ENUMs.

Dimitri Fontaine sent in seven revisions of a patch to add EXTENSIONs.

Robert Haas reviewed and revised the patch for knngist.

Terry Laurenzo sent in an alternative patch to add JSON support to

Peter Eisentraut added an "all" option for network interfaces to
pg_hba.conf.  This has the same functionality as specifying behavior
for (IPv4) and ::/0 (IPv6) taken together.

Greg Smith reviewed and revised the patch to add MERGE.

Andres Freund sent in a WIP patch to implement cancelling "<IDLE> in
transaction" connections.

Brendan Jurd sent in a patch to make keywords in pg_hba.conf

			Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group:

pgsql-de-allgemein by date

Next:From: Andreas 'ads' ScherbaumDate: 2010-10-19 21:28:32
Subject: PGDay Europa 2010 Registrierung geöffnet
Previous:From: Andreas 'ads' ScherbaumDate: 2010-10-11 07:32:15
Subject: == Wöchentlicher PostgreSQL Newsletter - 10. Oktober 2010 ==

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