Avoiding upgrade backlash - Mailing list pgsql-docs

From Josh Berkus
Subject Avoiding upgrade backlash
Date
Msg-id 200711121442.31233.josh@agliodbs.com
Whole thread Raw
Responses Re: Avoiding upgrade backlash
Re: [pgsql-advocacy] Avoiding upgrade backlash
List pgsql-docs
Hackers,

I'm seeing from reports on IRC that 8.3 may cause an unprecedented number
of upgrade issues for users who have old, badly-written applications.
Stefan K, for example, was reporting the necessity of re-writing 3000
lines of his PL/pgSQL code on an older app (about 10%).

While we are right to choke down abuse of implicit casting, it might be a
good idea to give users stronger warnings and instructions.

I'm thinking that we need to warn everyone about:
1) They need to use 8.3's pg_dump, not the old version, to upgrade (this is
always true but now doing it wrong will break a lot more users).
2) They need to check for bugs
3) If Robert gets his type-cast backport package together, the location of
that.

I'm thinking this warning should go (prominently) into the release notes,
the community notice, and the extended web release.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
Next
From: Tom Lane
Date:
Subject: Re: Avoiding upgrade backlash