== PostgreSQL Weekly News - October 27th 2004 ==

== PostgreSQL Weekly News - October 27th 2004 ==

 Headlining this weeks action was a security release for 7.2.6, 7.3.8, and
7.4.6.  The security changes revolve around a potential vulnerability in
pg_ctl, though be sure to read the specific release notes of your particular
version for other fixes that were included. By now downloads should be
available at all the usual places including FTP mirrors and Bittorrent.

 Of course there was also a new beta package released on Monday. This is
PostgreSQL 8.0 Beta 4, and should also be available on all FTP mirror sites
and Bittorrent. There were numerous fixes from the previous beta package, be
sure to check the announcement for the full list. A few of the highlights for
this past week include fixing a missing index access check in lazy vacuums,
removing several unnecessary casts, marking pg_tablespace as a shared
catalog, correctly writing the win32 config files as text files rather than
binary files, avoiding an overflow in cost_sort when work_mem exceeds 1GB,
and prevention of the loss of communication sync when an oversized message is
sent to the server.

 Other changes include syncing the timezone database with the latest zic
database, adding a GUC_SUPERUSER_ONLY flag into the code to mark variables
that should not be visible to non-superusers, and tweaking the ALTER COLUMN
TYPE code to remove any implicit coercion operations appearing at the top
level of the column's old default expression before adding an implicit
coercion to the new column type, solving some issues with default values no
longer being valid with comparable data types. The use of ad-hoc Min, Max,
and Abs macros in various contrib modules was removed in favor of using the
standard macros in the core back end code and referential integrity actions
are no longer allowed to be defferred (only the NO ACTION check is
defferable), bringing us in closer compliance with the sql standard.



== PostgreSQL Product News ==

IONIC Releases RedSpider Web 3.2 with 3D Services and PostGIS Support
http://www.gisuser.com/content/view/3686/

GForge 4.0 Released
http://gforge.org/forum/forum.php?forum_id=150

PostgreSQL 8.0.0 Beta 4 Now Available
http://www.postgresql.org/news/235.html

PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
http://www.postgresql.org/news/234.html

Slony-I 1.0.5 (PostgreSQL Database Replication) released
http://www.postgresql.org/news/233.html



== PostgreSQL In The News ==

The Power of Linux
http://www.ameinfo.com/news/Detailed/47305.html

Allowing Registration-Required Binary Downloads
http://www.onlamp.com/pub/a/php/2004/10/21/binary_downloads.html

Idavoll 2: PostgreSQL backend (blog)
http://ralphm.net/blog/2004/10/18/idavoll2

The Business Value of PGSuite  (blog)
http://jaredtech.blogspot.com/2004/10/business-value-of-pgsuite.html



== PostgreSQL Events ==

LinuxWorld Conferance: Frankfurt, Germany: October 26-28
PostgreSQL will once again have a booth at the LinuxWorld Conference & Expo.
http://www.linuxworldexpo.de/

Free PostgreSQL Training: Malvern, Pennslyvania: October 30
Bruce Momjian will cover PostgreSQL Administration and tuning.
http://www.chariotsolutions.com/postgresql.jsp

Vanmtagem + Developers 2004: Lisbon, Portugal: November 15-19
Several sessions on PostgreSQL, relational modelling, SQL, and more.
http://www.v-developers.com



== PostgreSQL Weekly News - October 27th 2004 ==
On the Web:
http://www.postgresql.org