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

== PostgreSQL Weekly News - May 11th 2004 ==

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: == PostgreSQL Weekly News - May 11th 2004 ==
Date: 2004-05-11 16:41:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
== PostgreSQL Weekly News - May 11th 2004 ==

        With a lot of talk the last couple of weeks about "Enterprise 
Features" it was nice to see a pickup in commit activity this week even if it 
wasn't for any of the favored sons. Well, that is not entirely true since a 
couple of this weeks changes will be huge for some people out there; the 
point is that progress is progress and this week was another good step 

        This weeks biggest feature add comes in the form of an overhaul to the 
ALTER TABLE command. ALTER TABLE ADD COLUMN now supports defaults and NOT 
NULL constraints as per the SQL spec. We now also have an implementation of 
ALTER COLUMN TYPE which will allow a change between any two datatypes as long 
as you can specify how to convert the values. Multiple ALTER actions can now 
be carried out in a single ALTER command as well (ie. adding two new columns 
in one command). Finally, after some discussion, ALTER COLUMN TYPE was made 
to preserve clustered status for indexes it doesn't modify, and the ALTER 
TABLE CLUSTER ON code was cleaned up in a number of places. Thanks go out to 
Rod Taylor and Tom Lane for their work on these much anticipated features.

        Some work was done to make PostgreSQL to get past undesirable locale 
behavior for case conversion of basic ASCII letters found in the Turkish 
language. All uses of strcasecmp and strncasecmp were removed in favor of new 
functions pg_strcasecmp and pg_strncasecmp, and most direct uses of toupper 
and tolower were removed in favor of pg_toupper and pg_tolower.  These 
functions use the same notions of case folding already developed for 
identifier case conversion. The straight locale-based folding was left in 
place for situations where we are just manipulating user data and not trying 
to match it to built-in strings, for example, the SQL upper() function.

        Rounding out the week were several smaller changes including removing 
the use of the term NATURAL CROSS JOIN per the SQL spec,  erasing MD5 user 
passwords when a user is renamed (since the username is used as salt for the 
MD5 password), several patches from the win32 group including one to allow 
whitespaces in the db/install directory, and row expressions are now allowed 
in all places of the expression syntax, which means you could now pass a 
ROW() construct to a function that accepts a rowtype parameter. This is 
another step in the work being done to make rowtype values into first-class 
citizens inside the database.

        In other big news, the new project hosting infrastructure was 
officially announced this week, available at 
Currently all new projects are welcome, and the team hopes to begin moving 
projects from the old site soon. The new site uses code 
from the gforge project; a highly popular, open source collaborative software 
development tool. It is based on PostgreSQL and PHP (among other open source 
tools) and has a thriving development community behind it. We're happy to be 
taking this step forward, but also want to give special thanks to Chris Ryan 
for his efforts over the last several years in maintaining the gborg 

== PostgreSQL Product News ==

Bricolage 1.8.0 Released

Announce: PgBrowse-0.9

PgOleDb version released

OFIA 2.2 adds Linux and Portal support

Nexonia Inc. Announces Web-Based Expense Report and Timesheet System

== PostgreSQL In the News ==

FileMaker to PostgreSQL Migration with FmPro Migrator on Windows

pgFoundry Open For Business

PostgreSQL 7.4

== Upcoming Events ==

European Regional Open Source Conference: Yerevan, Armenia: June 28-30
Bruce Momjian will be speaking at the Conference

OSCon: Portland, OR. USA: July 26-30
There will be a PostgreSQL Track with many community members participating.

== PostgreSQL Weekly News - May 11th 2004 ==
Don't forget to read Elein Mustain's Weekly Summary of the PostgreSQL
General Mailing List

On the Web:

pgsql-announce by date

Next:From: Robert TreatDate: 2004-05-17 20:53:07
Subject: == PostgreSQL Weekly News - May 17th 2004 ==
Previous:From: Marc G. FournierDate: 2004-05-07 21:06:31
Subject: Strengthing mail restriction rules in Postfix

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