"large" attachments (was Re: [rt-devel] rt notes)
alex at pilosoft.com
Mon Sep 18 17:30:47 EDT 2000
On Mon, 18 Sep 2000, J.D. Falk wrote:
> On 09/17/00, Jesse <jesse at fsck.com> wrote:
> > > 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. :)
> > >
> > *nod* One thing I've been vaguely pondering is the idea of storing "large"
> > attachments on disk, rather than in the database. This isn't something I'm
> > thrilled with, but it may be necessary to deal with many databases' broken
> > large-object handling.
I would really strongly suggest you don't do that. Better to do it right,
dealing with all sillinesses of databases if necessary than do it wrong
There aren't that many of them, its just postgres being annoying but you
can work around using lztext or in 7.1, it's completely fixed.
More information about the Rt-devel