== PostgreSQL Weekly News - April 12th 2004 ==

== PostgreSQL Weekly News - April 12th 2004 ==

A quiet week of development on the main project, but several
interesting developments took place in the world at large. Probably one of
the more meaningful items was the release of the SQL:2003 spec. Anyone
interested in database design should probably keep an eye out as more
articles appear discussing some of the changes involved; I've included a link
to a synopsis below.

Meanwhile, back in PostgreSQL world, we have a short list of changes
to run through. The psql program now shows CLUSTER information when using \d
on a relevant object. The copy command was also given some error checking to
prevent folks from using a delimiter which appears in the COPY NULL string.
The statement logging facilities were given the ability to log based on DML
and DDL type statements among other options (check the development docs for
implementation specifics). The optimizer now keeps better track of
sort-ordering used in set operations to help avoid redundant sorts at higher
levels.

Two changes worth special mention this week involved the breaking of
backwards compatibility of previous PostgreSQL releases. The first involved
fixing a bug that allowed for a century number 0 and millennium number 0
which was fixed. The other change makes psql's \copy stdin/stdout read from
command input/output and adds a pstdin/pstdout to read from psql's
stdin/stdout. Both of these changes will be labeled in the complete changelog
for 7.5, but it is always nice to get the word out as early as possible.

One last bit of news was an update on another very promising
replication solution for PostgreSQL known as PGCluster. PGCluster is a BSD
licensed, multi-master and synchronous replication solution, currently based
on 7.3.4 sources. For those interested in learning more about PGCluster, you
can check out the project website at
http://hiroshima.sraw.co.jp/people/mitani/jpug/pgcluster/en/.

== PostgreSQL Product News ==

Version 1.0.0.7 of OLE DB released
http://gborg.postgresql.org/project/oledb/news/newsfull.php?news_id=167

Minq Software Ships New Version of DbVisualizer
http://www.emediawire.com/releases/2004/4/emw116727.htm

== PostgreSQL In the News ==

Data Mining Email
http://www.onlamp.com/pub/a/onlamp/2004/04/08/datamining_email.html

Local Linux site rates hardware compatibility
http://www.computerworld.co.nz/news.nsf/0/4C07674A112811BFCC256E6F007289AC

Analyzing PostgreSQL SQL usage
http://rootprompt.org/article.php3?article=6497

SQL:2003 Summary
http://www.acm.org/sigmod/record/issues/0403/E.JimAndrew-standard.pdf

== Upcoming Events ==

An Evening With Bruce Momjian: New York, NY: April 13
SRA America is sponsoring a get-together with Bruce Momjian
http://www.postgresql.org/events/194.html

OSCon: Portland, OR. USA: July 26-30
There will be a PostgreSQL Track with many community members participating.
http://conferences.oreillynet.com/os2004/

== PostgreSQL Weekly News - April 12th 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