== PostgreSQL Weekly News - October 15th 2003 ==

== PostgreSQL Weekly News - October 15th 2003 ==

Folks continue to hammer on beta4 as issues kept trickling in. There
are also a couple of open items left to be dealt with, but those should
be wrapped up soon, so hopefully we'll see another release in the next
few days. Since there aren't too many changes this week, let's spin on
through them.

Installation tweaks seems to be some of the most prevalent changes,
which is no surprise really as the build process gets hammered the most
during the beta cycle. Some of those changes include adding quotes
around -O settings in the win template, centralizing the optimization
defaults into configure.in rather than the template files, adding
compile -O flag to configure only for non-debug mode, and removing the
"registration" message at the end of install.

Other changes this week included a change in logging, changing the word
query to statement, and making log_duration print when
log_min_duration_statement prints. A fix for improper usage of
snprintf() in contrib/pg_dumplo was put in. We now ensure that "--"
comments extend to the end of a line. The pg_id program now compiles
correctly on Win32. Some NULL regression tests were added. Access to the
variable m_preparedCount in JDBC via synchronized functions is now
protected to prevent multiple threads using automatic cursors on the
same connection from stomping over each others cursor. A core dump when
trying to start pg_autovacuum as root was fixed.

setRelhassubclassInRelation() was adjusted to not perform actual
heap_update when the pg_class.relhassubclass value is already correct
which should avoid most cases of the "tuple concurrently updated"
problem that was recently reported by Robert Creager. Initdb was
modified to determine the number of max_connections first, then set
shared buffers, to avoid corner cases where max_connections end up
unreasonably small due to shared_buffers hogging too much shmem space.
The pull_up_subqueries() function in the optimizer now copies the
subquery before starting to modify it. Tab completion in psql was
tweaked to use PQEscapeString, ensuring that queries are not messed up
by quotes or backslashes in words that are being matched to database
names.

Documentation oriented fixes this week included a tweak to
pg_autovacuum's README, an update to the Solaris FAQ, an update to the
Russian FAQ, some extra mentions of using logrotate, a mention of the
LOCALTIME/LOCALTIMESTAMP functions when dealing with dates/times, and
the addition of sort_mems effects on restore and run time performance.

== PostgreSQL Product News ==

MicroOLAP releases ISQL for Postgres v1.2
http://www.microolap.com/products/dba/pgisql.htm

plPerl trigger support available for beta testing
http://www.commandprompt.com/entry.lxp?lxpe=285

FireHOL R5 1.159 (Adds PostgreSQL support)
http://www.net-security.org/software.php?id=307

== PostgreSQL In the News ==

Use PostgreSQL and PHP on Windows
http://www.sitepoint.com/article/1233

University students in Mexico promote free software
http://newsforge.com/newsforge/03/10/15/208238.shtml?tid=19

Oracle offers up database to the little guys
http://www.theregister.co.uk/content/53/33299.html

MDB Tools project (blog)
http://www.araucaria.uklinux.net/blog/2003_10_05_archive.html#106577972238905956

== Upcoming Events ==

PHP-Con West: Santa Clara, California: October 21-24
Josh Berkus & Erez Ascher, and Steve Lane are giving two presentations
on PHP + PostgreSQL
http://www.php-con.com/2003/west/

LinuxWorld Conference & Expo 2003 : Frankfurt, Germany : October 27-29
PostgreSQL will have a booth at the LinuxWorld Conference
http://www.linuxworldexpo.de/

International PHP Conference: Frankfurt, Germany: November 2-5
Bruce Momjian will be presenting several PostgreSQL talks at this year's
International PHP Conference.
http://www.phpconference.de/2003/

== PostgreSQL Weekly News - October 15th 2003 ==
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