== PostgreSQL Weekly News - January 26th 2004 ==

== PostgreSQL Weekly News - January 26th 2004 ==

Another fine week of development capped off by a late-edition weekly
news :-) A number of items to run through and a structural change of note, so
let's get to it.

A couple of fixes put in this week were back-patched into the 7.4
branch for inclusion into the next release. One fix was a missed optimization
in the executor to avoid unnecessary projections when scanning tables where
all columns are needed was put in, thanks to Mike Mascari for the initial
report. Another bug in pg_dump setting incorrect database LOCATION for 7.0.*
servers was fixed, and a problem with dropped column in pltcl triggers,
reported by Patrick Salmon, was also fixed.

On the main branch, some low level discussions on the GEQO algorithm,
and close expection from Tom Lane, have lead to changes in some of the
default GEQO parameters, knowledge of SQL heuristics inside GEQO, and
improved documentation on the subject.Jan Wieck has also implemented a first
pass at background writer functionality, giving folks running dedicated
servers a way to improve variance of i/o operations of the server. Neil
Conway spent some time cleaning up psql's memory manipulation. ECPG added
WHENEVER NOT_FOUND functionality to SELECT/INSERT/UPDATE/DELETE syntax. A
behavioral change was put in to allow folks to set a schema search path that
includes non-existent schema. In the past, this would have resulted in an
ERROR, but this functionality is needed by pg_dump in some restoration cases,
so it now emits a NOTICE. There were also a couple of documentation
improvements including the addition of an example illustrating how to call
functions that take composite types was added into the docs. Some examples on
using PREPARE and EXECUTE functionality were also added.

One last item was the final removal of the remaining JDBC Driver code
was moved out of the main source tree and given it's own project page on
gborg at http://gborg.postgresql.org/project/pgjdbc/projdisplay.php, and of
course http://jdbc.postgresql.org will also continue to work. Hopefully this
will allow the JDBC folks to do more independent releases and not be tied
down to the main source releases.

== PostgreSQL Product News ==

Sun Cobalt update for PostgreSQL
http://www.secunia.com/advisories/10674/

OpenFTS 0.36 Released
http://freshmeat.net/projects/openfts/?branch_id=19183&release_id=149197&topic_id=93



== PostgreSQL In the News ==

Linux World Expo - Day 2
http://www.freebsddiary.org/linuxworldexpo-2004-part5.php

More Agencies Pick Open Source Software
http://www.govexec.com/features/1203/1203managetech.htm



== Upcoming Events ==

New York PHP Meeting: New York, New York: January 27
Bruce Momjian will be presenting an introduction to PostgreSQL
http://nyphp.org/content/calendar/view_entry.php?id=50&date=20040127

NordU Usenix 2004: Denmark: January 28 - January 30
Bruce Momjian will still be giving his PostgreSQL tutorial
http://www.nordu.org/NordU2004/

Linux Solutions 2004: Paris, France: February 3-5
Bruce Momjian will be presenting
http://www.solutionslinux.fr/en/index.php


== PostgreSQL Weekly News - January 26th 2004 ==
Don't forget to read Elein Mustain's Weekly Summary of the PostgreSQL
General Mailing List http://www.varlena.com/GeneralBits/

On the Web:
http://www.postgresql.org
http://advocacy.postgresql.org