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

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

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: == PostgreSQL Weekly News - January 26th 2004 ==
Date: 2004-01-27 02:37:55
Message-ID: 200401262137.55689.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-announce
== 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


pgsql-announce by date

Next:From: Marc G. FournierDate: 2004-01-27 19:28:02
Subject: Looking for mail relays ...
Previous:From: Martijn van OosterhoutDate: 2004-01-26 01:25:39
Subject: Re: Touch row ?

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