I’ve found that the database changes between RT beta 2 and RC 3 cannot
be made via the SQL commands noted in the RC4 release notes. The
primary problem is that bytea data cannot be cast by PostgreSQL to
text. So naturally, I wrote a Perl script to do the job and now attach
it for other PostgreSQL users to use. If you’re running a version of
PostgreSQL prior to 7.3, you’ll want to comment out the line that drops
the old column.
Note: This script does not address the problems adding the
"LastUpdated" column to the “session” table. I did a database dump to
fix that one.
update_rt (668 Bytes)