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

== PostgreSQL Weekly News - May 24 2009 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - May 24 2009 ==
Date: 2009-05-25 04:06:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
== PostgreSQL Weekly News - May 24 2009 ==

PostgreSQL 8.1 beta 2 released.  Test!

PgCon was another smash hit, with increased attendance in the face of
decreased attendance at other conferences.  Watch for video of the
presentations soon.

The video from the May 12, 2009 SFPUG meeting, "BIRT & PostgreSQL," is
now available for viewing or download from the

JPUG 10th Anniversary Conference has started its Request for

MicroOLAP Database Designer 1.2.8beta1, a Windows-based designer for
PostgreSQL, released.

The PostgreSQL/PostGIS community will be meeting in Zurich on June 6,
2009.  Details (de_CH) below:öck

== PostgreSQL Product News ==

== PostgreSQL 8.4 Feature of the Week ==

Warm Standby: If setting up Warm Standby confused you before, give it
a try with 8.4; it's now user-friendly.

== PostgreSQL Tip of the Week ==

Until 8.4's Common Table Expressions and 8.5's SQL/MED come out, you
can use the "tablefunc" contrib module includes functions for
connect_by() joins and querying one database from another,

== PostgreSQL Jobs for May ==

== PostgreSQL Local ==

PGDay Junin / Buenos Aires Unnoba will be on June 6, 2009.

Save The Date: pgDay San Jose.  Sunday, July 19th 2009 immediately
before OSCON.  CfP, more info TBA!

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
November 6-7, 2009.

== PostgreSQL in the News ==

Planet PostgreSQL:

PostgreSQL Weekly News is brought to you this week by David Fetter and
Josh Berkus.

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot)

== Applied Patches ==

Peter Eisentraut committed:

- Some documentation cleanup for the addition of the KOI8U encoding.
  Change all (remaining) mentions of KOI8 to the new canonical form
  KOI8R.  Add information about the available conversions for KOI8U.

- Refer to tables by id, not by "the following table", because tables
  are in theory floating elements.

- In pgsql/src/backend/catalog/sql_features.txt, update SQL
  conformance entries for window functions functionality

- In pgsql/src/tools/editors/emacs.samples, add some instructions on
  how to customize emacs for working on the SGML sources.

- Add documentation string for LDFLAGS_SL in configure --help output.

- In pgsql/src/tools/editors/emacs.samples, fix sgml-mode example.
  Thanks, Andrew Dunstan.

- In pgsql/src/bin/pg_dump/pg_dump.c, convert some messages to use
  ngettext().  Author: Euler Taveira de Oliveira.

Tom Lane committed:

- In pgsql/src/interfaces/libpq/fe-connect.c, make pwdfMatchesString()
  a little more careful about matching * fields.

- Fix bug #4814 (wrong subscript in consistent-function call), and add
  some minimal regression test coverage for matchPartialInPendingList().

- Fix LIKE's special-case code for % followed by _.  I'm not entirely
  sure that this case is worth a special code path, but a special code
  path that gets the boundary condition wrong is definitely no good.
  Per bug #4821 from Andrew Gierth.  In passing, clean up some minor
  code formatting issues (excess parentheses and blank lines in odd
  places).  Back-patch to 8.3, where the bug was introduced.

- Use more-portable coding for the check on handing out the last
  available relopt_kind value in add_reloption_kind().  Per Zdenek

Heikki Linnakangas committed:

- In pgsql/src/backend/commands/analyze.c, update relpages and
  reltuples estimates in stand-alone ANALYZE, even if there's no
  analyzable attributes or indexes. We also used to report 0 live and
  dead tuples for such tables, which messed with autovacuum threshold
  calculations.  This fixes bug #4812 reported by George Su. Backpatch
  back to 8.1.

- In pgsql/src/backend/commands/tablecmds.c, silence a gcc compiler
  warning about non-literal format string with no args when compiling
  with -Wformat-security. Fujii Masao.

Michael Meskes committed:

- Removed some unneeded variables and comparisons.

- More variables gcc moans about.

- Removed unsigned/signed mismatches.

- Removed comparison of unsigned expression < 0.

Teodor Sigaev committed:

- In pgsql/src/backend/utils/adt/tsvector.c, re-sort tsvector's
  lexemes in tsvectorrecv instead of emitting an error.  Basically,
  it's needed to support binary dump from 8.3 because the ordering
  rule was changed.  Per discussion with Bruce Momjian.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Simon Riggs sent in two patches to improve read-only scalability.

Pavel Stehule sent in another revision of the GROUPING SETS patch.

Jim Nasby sent in a patch to add a feature to vacuumdb that allows
analyze-only as an option.

Robert Haas sent in a patch to add parenthesized options to EXPLAIN.

Pavel Stehule sent in a patch to clean up some syntax warnings in

Zdenek Kotala sent in two patches to do some cleanup to help

Tatsuhito Kasahara sent in a patch to fix ja.po.

Steve Prentice sent in two versions of a patch to supplement Pavel
Stehule's patch for named and mixed notation support in 8.5.  Pavel
sent in a followup that touches the main parser.  Steve sent an
updated patch.

Dimitri Fontaine sent in a document patch for GiST extensions.

Adriano Lange sent in a patch implementing 2PO, an alternative to
the GEQO for optimizing large joins.

Andres Freund sent in a patch to allow EXPLAIN ANALYZE to show
counts of discarded tuples.


pgsql-announce by date

Next:From: David FetterDate: 2009-05-25 13:28:25
Subject: Re: == PostgreSQL Weekly News - May 24 2009 ==
Previous:From: Tatsuo IshiiDate: 2009-05-21 15:04:58
Subject: Request for proposals: PostgreSQL Conference 2009 Japan - JPUG 10th Anniversary Conference -

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