== PostgreSQL Weekly News - March 1st 2004 == - Mailing list pgsql-announce
From | Robert Treat |
---|---|
Subject | == PostgreSQL Weekly News - March 1st 2004 == |
Date | |
Msg-id | 200403011404.34442.xzilla@users.sourceforge.net Whole thread Raw |
List | pgsql-announce |
== PostgreSQL Weekly News - March 1st 2004 == Work on the 7.3.6 release is pretty much done, so keep an eye on the -announce mailing list or the PostgreSQL website for the full announcement sometime this week. After than 7.4.2 will be packaged up, so we may not see that until the following week. Meanwhile work in 7.5 continues at a good pace. Postmaster start has been changed to do a direct probe to determine the the maximum number of openable files and the number already opened, which eliminates problems that have been encountered by less than reliable information in sysconf(_SC_OPEN_MAX). The opendir/closedir calls throughout the backend were replaced with AllocateDir and FreeDir routines which can avoid failing on EMFILE/ENFILE conditions whenever possible, and will prevent leakage of directory descriptors if an elog() occurs while one is open. A bug which caused a crash when rowtype arguments to plpgsql functions were NULL was fixed. The remove_redundent_join_clauses() function in the optimizer was adjusted to ensure that it removes the more expensive clause, which makes a much more significant difference since we are capable of handling sub-selects for clauses. A bug with the anyarray type's data-alignment in pg_statistic was fixed. The fix involves a change to the system tables, so while it was back-patched into 7.4.x, it will only be available to new installs. There is a work around to this available in the mailing list archives should you need to use anyarray with values that require double alignment. The pg_dump tool will now set a client encoding at the start of the dump based on the encoding of the database to be dumped. This should help with importing into databases that may not have the same default encoding. Some enhancements were done to increase the robustness of dblink when dealing with custom data types, which should be especially handy for add-ons like tsearch2. The often discussed "dollar quoting" feature had its first implementation added to the backend lexer, psql, and plpgsql. There is still work needed to be done to make this feature complete, but this means the ball is officially rolling. == PostgreSQL Product News == phpPgAdmin 3.3 Released http://www.postgresql.org/news/171.html pgtclng 1.5.0 Next-generation PostgreSQL Tcl interface released http://archives.postgresql.org/pgsql-interfaces/2004-02/msg00085.php OpenPKG 2.0 released http://lxer.com/module/newswire/view/5718/ Postgres Forms (pfm) available as beta version. http://gborg.postgresql.org/project/pfm/news/newsfull.php?news_id=160 == PostgreSQL In the News == Porting Visual Basic apps to Linux http://www.newsforge.com/programming/04/02/25/1959200.shtml Is Dynamic CRM Taking Off? http://www.intelligententerprise.com/showArticle.jhtml?articleID=17800078&pgno=2 LHelp.com Forays Into Indian Market With iCustomer http://www.cxotoday.com/cxo/jsp/index.jsp?section=News&file=template0.jsp&subsection=Software&storyid=690 Zinf: The Linux Answer to iTunes (blog) http://thelostolive.net/tlo/comments.php?id=2005_0_1_0_C MySQL & Sequences (blog) http://www.evilmagic.net/archives/2004_02_28.html == Upcoming Events == Chemnitzer Linux-Tag: Chemnitz, Germany: March 6-7 Peter Eisentraut will organize a table and will make a presentation http://www.tu-chemnitz.de/linux/tag/2004/allgemeines/ == PostgreSQL Weekly News - March 1st 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: