== PostgreSQL Weekly News - December 7th 2004 ==

== PostgreSQL Weekly News - December 7th 2004 ==

After much conversation and debate, the core team decided to release
PostgreSQL 8.0.0 RC1 this past week, putting us into the final crunch time of
the 8.0 development cycle. The current plan is to make final release around
December 15th if everything goes well. All port reports, translations, and
last minute documentation improvements should be submitted ASAP. (Current
port reports can be found at
http://developer.postgresql.org/docs/postgres/supported-platforms.html) There
will be at least one more RC package before final release, so keep an eye for
it as things will move pretty quickly at this stage.

So what fixes should we be looking for in the latest package? The
readline/libedit selection code was adjusted to more reliably prefer readline
over libedit. The planner was changed to make use of the current true disk
size rather than the values in pg_class in a number of scenarios. This
removes a number of backend workarounds and should produce more reliable
query plans. Libpq will now build on MS Visual Studio .Net 2003 on Windows
XP. VACUUM FULL FREEZE support was disabled due to potential errors that
could result in it's use. This will probably be fixed in a later release,
but due to the late stage of the beta, the work around of using VACUUM FULL
and VACUUM FREEZE sequentially was deemed acceptable. Lastly, an issue with
internal snapshots for deferred triggers were was fixed.

== PostgreSQL Product News ==

EMS PostgreSQL Manager 2.7 released
http://archives.postgresql.org/pgsql-announce/2004-12/msg00001.php

pgAdmin III 1.2.0 Released
http://archives.postgresql.org/pgsql-announce/2004-12/msg00000.php

DBD::PgSPI 0.02
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00255.php

== PostgreSQL In The News ==

PostgreSQL 8 is "enterprise ready"
http://www.builderau.com.au/program/work/0,39024650,39160081,00.htm

ALTER TABLE in PostgreSQL 8.0 (blog)
http://www.gnegg.ch/archives/alter_table_in_postgresql_80.html#000218

The Metadata Problem With Databases (blog)
http://joseph.randomnetworks.com/archives/2004/11/30/the-metadata-problem-with-databases/

== PostgreSQL Events ==

(Note: Looks like everyone's calendar has been cleared for next year, so this
week we bring you a couple of training sessions to be looking for in the new
year)

PostgreSQL Bootcamp, Atlanta, GA, Big Nerd Ranch,
http://www.bignerdranch.com/classes/postgresql.shtml

PostgreSQL Training, SRA America, New York, NY.
http://www.sraapowergres.com

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