== 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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-announce by date

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