Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


PostgreSQL Weekly News - January 15 & 22, 2003

Jan 26, 2003, 17:00 (0 Talkback[s])

[ Thanks to Robert Treat for this link. ]

== PostgreSQL Weekly News - Jan 15th 2003 ==

Lots of bug squashing in the pipes this week.  D'arcy Cain fixed some
issues with python support. There were also fixes for cursor support, backups, some optimization fixes, and a patch from Neil Conway was submitted for
fixing a segfault condition with plpgsql. Even Red Hat got into the mix, 
releasing  new RPM's for those running older versions of PostgreSQL that
contain some of the fixes that came about in version 7.3.
See http://rhn.redhat.com/errata/RHSA-2003-001.html for more.


On the features front, the ora2pg utility has been updated as well to work with 7.3 schema support. All those switching from Oracle to PostgreSQL are encouraged to check it out. 

There has also been good activity on the international front; the Brazilian
PostgreSQL community has a translated the reference manual to Portuguese and
also has several tutorials on their website.
(http://pgsqlbr.querencialivre.rs.gov.br/) 



== PostgreSQL Product News ==

PostgreSQL Session Handler for PHP v2.0 Released

http://freshmeat.net/releases/109301/


CONNX Data Synchronization and VSAM VSE Support in New Release; CONNX
Solutions Announces 8.8 Release

http://www.prnewswire.com/cgi-bin/stories.pl?ACCT=SVBIZINK3.story&STORY=/www/story/01-09-2003/0001868800&EDATE=THU+Jan+09+2003,+07:45+AM



== PostgreSQL In the News ==

PostgreSQL 7.3 Set Returning Functions by Stephan Szabo

http://techdocs.postgresql.org/guides/SetReturningFunctions



== Upcoming Events ==

Linux.Conf.Au : Perth, Australia : January 22-25
Gavin Sherry will be providing a detailed overview of PostgreSQL, and be running a BoF as well.

http://www.linux.conf.au

http://www.linux.conf.au/abstracts.cgi?id=T45

FOSDEM: Brussels, Belgium:  February 8-9
A two-day PostgreSQL training track will be part of the FOSDEM conference.

http://candle.pha.pa.us/fosdem/

http://www.fosdem.org/index



== PostgreSQL Weekly News - Jan 15th 2003 ==

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


_______________________________________________________


== PostgreSQL Weekly News - Jan 22nd 2003 ==

    An important discussion about the needs for a 7.2.4 release took
place this week, and while no decision has been made, some commits to
the REL7_2_STABLE branch have been applied. In particular were fixes for
integer overflow (Neil Conway) and fixing some issues with Vacuum (Tom
Lane).  It's likely other fixes would be applied before a release so if
your running 7.2.X and can't upgrade to 7.3.X for some reason, keep an
eye out for this. If you really need it, you might want to jump in on
the discussion on the -hackers list, but be aware that even with a 7.2.4
release, there will still be plenty of fixes and enhancements available
in 7.3.X that can't be back-patched, so upgrading to 7.3.X is still
strongly recommended. 

    This week saw an enhancement in error notification for 7.4, so that 
information about detected deadlock cycles is easier to find. There were
also a couple of enhancements to the optimizer regarding query
optimization. Those that want nitty-gritty details can check out the cvs
logs. 

    From the "let's try and head this one off at the pass department"
some new information was added to the FAQ for question 4.8 regarding
indexes. Reading the FAQ is always a good idea, you can view the most
current version at http://www.PostgreSQL.org/docs/faq-english.html.

    Several improvements for JDBC support were committed this week; one
improving the getImportedKeys function (Kris Jurka), one to better
support java timestamps (Florian Wunderlich), and one fixing a bug
involving timestamps without time zone (Rhett Sutphin). 

    I'm sure you'll all be happy to know some work is being done of
those darn IN queries. The latest change allows IN clauses appearing at
top level of WHERE can now be handled as joins. There are two
implementation techniques: the executor understands a new JOIN_IN
jointype, which emits at most one matching row per left-hand row, or the
result of the IN's sub-select can be fed through a DISTINCT filter and
then joined as an ordinary relation. 


    And last, but definitely not least, Jan Wieck has submitted a patch
for native windows support. The patch files are based on the 7.2.1 tree
and compile against both Red Hat Linux and Windows 2000. There is still
a lot to do, but it's a good start and I think a big step for
PostgreSQL. I'd like to personally give thanks to PeerDirect
corporation, who employs Jan and contributed the work back to the
PostgreSQL community. You can view Jan's original announcement at
http://archives.postgresql.org/pgsql-hackers/2003-01/msg00725.php

== PostgreSQL Product News == 

OpenOSX shipping OpenDB 2.2 
http://maccentral.macworld.com/news/0301/17.openosx.php

PeerDirect Moves on Linux 
http://www.eweek.com/article2/0,3959,836211,00.asp



== PostgreSQL In the News == 

PostgreSQL affiliates .ORG domain 
http://www.computerworld.com.au/idg2.nsf/All/2ADD84E6EBCEADE9CA256CB30075FA01!OpenDocument&n=Sections&c=Software+Development

Battle of the Open Source Databases 
http://www.newsfactor.com/perl/story/20495.html



== Upcoming Events == 

Linux.Conf.Au : Perth, Australia : January 22-25 
Gavin Sherry will be providing a detailed overview of PostgreSQL, and be
running a BoF as well. 
http://www.linux.conf.au
http://www.linux.conf.au/abstracts.cgi?id=T45

Open Source Weekend : Ottawa, Canada : January 25-26 
PostgreSQL, Inc. will have a booth and be involved in panel discussions
at Open Source Weekend 
http://www.osw.ca/
http://www.pgsql.com/press/PR_OSW-03.html

FOSDEM: Brussels, Belgium:  February 8-9 
A two-day PostgreSQL training track will be part of the FOSDEM
conference. 
http://candle.pha.pa.us/fosdem/
http://www.fosdem.org/index



== PostgreSQL Weekly News - Jan 22nd 2003 == 

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


        ------------------------------------------------

Related Stories: