== PostgreSQL Weekly News - April 12th 2004 ==
От | Robert Treat |
---|---|
Тема | == PostgreSQL Weekly News - April 12th 2004 == |
Дата | |
Msg-id | 200404130116.54109.xzilla@users.sourceforge.net обсуждение исходный текст |
Список | pgsql-announce |
== 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
В списке pgsql-announce по дате отправления: