== PostgreSQL Weekly News - October 29 2006 == - Mailing list pgsql-announce
From | David Fetter |
---|---|
Subject | == PostgreSQL Weekly News - October 29 2006 == |
Date | |
Msg-id | 20061030071701.GC21311@fetter.org Whole thread Raw |
List | pgsql-announce |
== PostgreSQL Weekly News - October 29 2006 == The 8.1.5 PGDG RPMs have a serious bug. Do not use them until the next re-spin, which will be 8.1.5-6PGDG. Slides and media from July's PostgreSQL 10th Anniversary Summit are up. Anyone with photos or other media to contribute should contact Gavin Sherry <swm AT alcove.com.au> http://conference.postgresql.org/Program The dates for the next PostgreSQL Conference are May 21 to 24 in Ottowa, Ontario, Canada. A call for papers and additional information about the conference will be coming soon, but for now, mark your calendars. == PostgreSQL Product News == Moodle, a course management system, supports PostgreSQL http://moodle.org/ pgfouine 0.71 released. http://pgfoundry.org/projects/pgfouine/ Here are some of the reasons that Atlantis Process Control System works exclusively with PostgreSQL. http://satelliteforces.ca/postgreSQLAndAtlantis.html SQL Edge 2.2 released. http://www.baybreezesoft.com EMS has bundled all of their PostgreSQL tools together as EMS SQL Management Studio for PostgreSQL. http://www.sqlmanager.net The Open Technology Group is now offering PostgreSQL performance tuning training. http://www.otg-nc.com == PostgreSQL Jobs for October == http://archives.postgresql.org/pgsql-jobs/2006-10/threads.php == PostgreSQL Local == There is a gathering at UCB in Berkeley, California celebrating the 30th Anniversary of Ingres, a PostgreSQL predecessor, on November 29. http://www.eecs.berkeley.edu/IPRO/INGRES30/ == PostgreSQL in the News == David Fetter, Rodrigo Hjort, Fernando Ike, Alvaro Melo, Eduardo Mikos, Adilson de Oliveira and Fabio Telles Rodrigues will be speaking at Conisli. http://www.conisli.org/ Planet PostgreSQL: http://www.planetpostgresql.org/ General Bits, Archives and occasional new articles: http://www.varlena.com/GeneralBits/ PostgreSQL Weekly News is brought to you this week by David Fetter, Dave Page and Josh Berkus == Applied Patches == Tom Lane committed: - expression_tree_walker failed to let walker function see the immediate child node of a SubLink or SubPlan testexpr field. This bug resulted from replacing the old lefthand/exprs list fields with a simple expression field, and not remembering that expression_tree_walker is coded to save a few cycles by recursing directly to self on list fields (on the assumption the walker isn't interested in List nodes per se). On non-list fields it must of course call the walker. Possibly that hack isn't worth the risk of more such bugs, but I'll leave it be for now. Per bug report from James Robinson. - Fix check for whether a clauseless join has to be forced in the presence of outer joins. Originally it was only looking for overlap of the righthand side of a left join, but we have to do it on the lefthand side too. Per example from Jean-Pierre Pelletier. - Magnus Hagander's patch which tweaks zic.c to compile cleanly on MSVC: use CopyFile instead of CopyFileEx. This avoids a warning about the function not being present on older Windows versions. - Rewrite discussion of ORDER BY to emphasize the SQL99 expression case instead of the SQL92 output-column-ID case. - Stamp 8.2beta2. - Fix broken markup in release.sgml. - Remove an unnecessary HOLD_INTERRUPTS/RESUME_INTERRUPTS pair from pgsql/src/backend/storage/buffer/bufmgr.c. This was required back when RESUME_INTERRUPTS could actually execute ProcessInterrupts, but that hasn't been true since 2001. - Code cleanup for pg_buffercache, from Mark Kirkwood. Michael Meskes committed: - Small parser sync in ecpg. Peter Eisentraut committed: - In func.sgml, add some real descriptions to the multiargument aggregate functions rather than just showing the incomprehensible formulas. - Spellchecking and such on the docs. - Fix list of environment variables for configure. Remove some variables that are almost never used. Put documentation-related variables into the documentation chapter. Bruce Momjian committed: - Fix spelling mistake in docs. - Add missing file for documentation section on failover, replication, load balancing, and clustering options. - Add documentation section on failover, replication, load balancing, and clustering options to. - Correction, add URL on 'Add estimated_count(*) to return an estimate of COUNT(*)' to TODO list. - Add URL for 'Speed up COUNT(*)' to TODO list. Neil Conway committed: - Euler Taveira de Oliveira's patch which fixes a typo in backup docs. == Rejected Patches (for now) == Zdenek Kotala's patch which makes COPY work with regproc and aclitem. Neil Conway's patch which changes GUC descriptions. Postponed to 8.3 because translators would need to do too much work now. == Pending Patches == Albert Cervera Areny submitted a patch which adds a GUC called temp_tablespaces. The patch is directed toward addressing the "tablespace for temporary objects and sort files" TODO item. Toru SHIMOGAKI submitted a patch meant to fix an overflow problem in pg_class.relchecks. Magnus Hagander submitted a patch which updates the MSVC build. Heikki Linnakangas submitted a patch which logs tuple freezes in the WAL per discussion on pgsql-bugs. Simon Riggs submitted a patch for new WAL records for relcache invalidation.
pgsql-announce by date: