RT PostgreSQL Database Upgrade


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.


David Wheeler AIM: dwTheory
david@kineticode.com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory@jabber.org
Kineticode. Setting knowledge in motion.[sm]

update_rt (668 Bytes)