[rt-devel] rt notes

ivan ivan-rt-devel at 420.am
Sat Oct 7 12:24:10 EDT 2000


On Sat, Oct 07, 2000 at 09:09:57AM -0700, ivan wrote:
> On Sun, Sep 17, 2000 at 02:52:34AM -0400, Alex Pilosov wrote:
> >
> > The things that are different in each database: 
> > a) datatypes (DATE vs TIMESTAMP, VARCHAR vs VARCHAR2, CLOB vs TEXT, etc)
> 
> > 5. Because current large-object interface in postgres is such a pain to
> > work with, I converted all columns to TEXT. However, postgres up to 7.1
> > won't allow you to put >8k of data into one row, which means things won't
> > quite work right. 7.1 is to be released sometime this year. :)  >
> 
> I'm working on the Pg port now.  Pg doesn't seem to have a `TEXT'
> datatype.  What do you suggest using instead of MySQL BLOBs? for Pg 7.0?

Nevermind, I've been up way too late.  I found it.

> This particular problem is going to be a doozy.  Yuck.

(8k limit etc.)  At least I seem to have mysql and Pg database both
working again.

-- 
meow
_ivan




More information about the Rt-devel mailing list