[rt-users] 2.x > 3.x

Jesse Vincent jesse at bestpractical.com
Wed Mar 12 12:40:17 EST 2003



On Wed, Mar 12, 2003 at 03:00:03PM +0000, Aaron Wilson wrote:
> 
> >>>>> On Wed, 12 Mar 2003, "Andy" == Andy Harrison wrote:
> 
>   Andy> rt2 db.  Used rt-2.0-to-dumpfile to create the rt dump.  Started
>   Andy> running the dumpfile-to-rt-3.0 and it looked like it was going to
>   Andy> work, but hit a snag.  Any clues on this one?
> 
>   Andy> (my theory is that it's just refusing to import an attachment with
>   Andy> the word 'obtundent' in it... ;)
> 
> The upgrade script doesn't correctly quote the Content part for the 
> postgresql type bytea (I think \ needs to be \\\\ amoung other things).

Interesting. That sort of sounds like a bug in DBD::pgsql's quoting
mechanism.

> 
> One (evil) fix is to change the schema to use text instead of bytea
> 
> A related question: why is the new postgresql schema using bytea instead of 
> text (as it used to in 2.0.x) ?  

So that we can evenutally stop base-64 encoding all attachments.


> Aaron
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the rt-users mailing list