Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - March 1st 2004 ==

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: == PostgreSQL Weekly News - March 1st 2004 ==
Date: 2004-03-01 19:04:34
Message-ID: 200403011404.34442.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: 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

Next:From: Marc G. FournierDate: 2004-03-03 14:08:52
Subject: PostgreSQL 7.3.6 Now Available ...
Previous:From: Paulovič MichalDate: 2004-02-28 17:31:21
Subject: SERIAL type - auto-increment grouped by other field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group