== PostgreSQL Weekly News - May 24 2009 ==

== PostgreSQL Weekly News - May 24 2009 ==

PostgreSQL 8.1 beta 2 released. Test!
http://www.postgresql.org/developer/beta

PgCon was another smash hit, with increased attendance in the face of
decreased attendance at other conferences. Watch for video of the
presentations soon.
http://www.pgcon.org/2009/

The video from the May 12, 2009 SFPUG meeting, "BIRT & PostgreSQL," is
now available for viewing or download from the media.postgresql.org
server:
http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov

JPUG 10th Anniversary Conference has started its Request for
Proposals.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

MicroOLAP Database Designer 1.2.8beta1, a Windows-based designer for
PostgreSQL, released.
http://microolap.com/products/database/postgresql-designer/

The PostgreSQL/PostGIS community will be meeting in Zurich on June 6,
2009. Details (de_CH) below:
http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-Hö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,
respectively.

== PostgreSQL Jobs for May ==

http://archives.postgresql.org/pgsql-jobs/2009-05/threads.php

== PostgreSQL Local ==

PGDay Junin / Buenos Aires Unnoba will be on June 6, 2009.
http://www.arpug.com.ar/trac/wiki/PgDayUnnoba

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.
http://www.pgday.eu/

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

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
Kotala.

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
tsquery_op.c

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

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.