[rt-users] RT PostgreSQL Database Upgrade

[David Wheeler]

Greetings,

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.

Regards,

David
-- 
David Wheeler                                     AIM: dwTheory
david at kineticode.com                              ICQ: 15726394
                                                Yahoo!: dew7e
                                                Jabber: Theory at jabber.org
Kineticode. Setting knowledge in motion.[sm]
-------------- next part --------------
A non-text attachment was scrubbed...
Name: update_rt
Type: application/octet-stream
Size: 668 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030402/1f68f55f/attachment.obj>
-------------- next part --------------