== PostgreSQL Weekly News - October 29 2006 ==

== PostgreSQL Weekly News - October 29 2006 ==

The 8.1.5 PGDG RPMs have a serious bug. Do not use them until the
next re-spin, which will be 8.1.5-6PGDG.

Slides and media from July's PostgreSQL 10th Anniversary Summit are
up. Anyone with photos or other media to contribute should contact
Gavin Sherry <swm AT alcove.com.au>
http://conference.postgresql.org/Program

The dates for the next PostgreSQL Conference are May 21 to 24 in
Ottowa, Ontario, Canada. A call for papers and additional information
about the conference will be coming soon, but for now, mark your
calendars.

== PostgreSQL Product News ==

Moodle, a course management system, supports PostgreSQL
http://moodle.org/

pgfouine 0.71 released.
http://pgfoundry.org/projects/pgfouine/

Here are some of the reasons that Atlantis Process Control System
works exclusively with PostgreSQL.
http://satelliteforces.ca/postgreSQLAndAtlantis.html

SQL Edge 2.2 released.
http://www.baybreezesoft.com

EMS has bundled all of their PostgreSQL tools together as EMS SQL
Management Studio for PostgreSQL.
http://www.sqlmanager.net

The Open Technology Group is now offering PostgreSQL performance
tuning training.
http://www.otg-nc.com

== PostgreSQL Jobs for October ==

http://archives.postgresql.org/pgsql-jobs/2006-10/threads.php

== PostgreSQL Local ==

There is a gathering at UCB in Berkeley, California celebrating the
30th Anniversary of Ingres, a PostgreSQL predecessor, on November 29.
http://www.eecs.berkeley.edu/IPRO/INGRES30/

== PostgreSQL in the News ==

David Fetter, Rodrigo Hjort, Fernando Ike, Alvaro Melo, Eduardo Mikos,
Adilson de Oliveira and Fabio Telles Rodrigues will be speaking at
Conisli.
http://www.conisli.org/

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter,
Dave Page and Josh Berkus

== Applied Patches ==

Tom Lane committed:

- expression_tree_walker failed to let walker function see the
immediate child node of a SubLink or SubPlan testexpr field. This
bug resulted from replacing the old lefthand/exprs list fields with
a simple expression field, and not remembering that
expression_tree_walker is coded to save a few cycles by recursing
directly to self on list fields (on the assumption the walker isn't
interested in List nodes per se). On non-list fields it must of
course call the walker. Possibly that hack isn't worth the risk of
more such bugs, but I'll leave it be for now. Per bug report from
James Robinson.

- Fix check for whether a clauseless join has to be forced in the
presence of outer joins. Originally it was only looking for
overlap of the righthand side of a left join, but we have to do it
on the lefthand side too. Per example from Jean-Pierre Pelletier.

- Magnus Hagander's patch which tweaks zic.c to compile cleanly on
MSVC: use CopyFile instead of CopyFileEx. This avoids a warning
about the function not being present on older Windows versions.

- Rewrite discussion of ORDER BY to emphasize the SQL99 expression
case instead of the SQL92 output-column-ID case.

- Stamp 8.2beta2.

- Fix broken markup in release.sgml.

- Remove an unnecessary HOLD_INTERRUPTS/RESUME_INTERRUPTS pair from
pgsql/src/backend/storage/buffer/bufmgr.c. This was required back
when RESUME_INTERRUPTS could actually execute ProcessInterrupts,
but that hasn't been true since 2001.

- Code cleanup for pg_buffercache, from Mark Kirkwood.

Michael Meskes committed:

- Small parser sync in ecpg.

Peter Eisentraut committed:

- In func.sgml, add some real descriptions to the multiargument
aggregate functions rather than just showing the incomprehensible
formulas.

- Spellchecking and such on the docs.

- Fix list of environment variables for configure. Remove some
variables that are almost never used. Put documentation-related
variables into the documentation chapter.

Bruce Momjian committed:

- Fix spelling mistake in docs.

- Add missing file for documentation section on failover, replication,
load balancing, and clustering options.

- Add documentation section on failover, replication, load balancing,
and clustering options to.

- Correction, add URL on 'Add estimated_count(*) to return an estimate
of COUNT(*)' to TODO list.

- Add URL for 'Speed up COUNT(*)' to TODO list.

Neil Conway committed:

- Euler Taveira de Oliveira's patch which fixes a typo in backup docs.

== Rejected Patches (for now) ==

Zdenek Kotala's patch which makes COPY work with regproc and aclitem.

Neil Conway's patch which changes GUC descriptions. Postponed to 8.3
because translators would need to do too much work now.

== Pending Patches ==

Albert Cervera Areny submitted a patch which adds a GUC called
temp_tablespaces. The patch is directed toward addressing the
"tablespace for temporary objects and sort files" TODO item.

Toru SHIMOGAKI submitted a patch meant to fix an overflow problem in
pg_class.relchecks.

Magnus Hagander submitted a patch which updates the MSVC build.

Heikki Linnakangas submitted a patch which logs tuple freezes in the
WAL per discussion on pgsql-bugs.

Simon Riggs submitted a patch for new WAL records for relcache
invalidation.