Re: [Gnumed-bugs] Attach documents - limitation on input into free text document description

[Karsten Hilbert]

On Thu, Nov 24, 2011 at 10:06:00AM +0100, Karsten Hilbert wrote:

> > I tried pasting a consultation into the free text area of
> > 
> >     Attach documents

You might have wanted to consider storing it as a Soap row
with an appropriate lead-in.

> > but on account of its length of 150 lines, ~ 2 pages ~ 8K of characters) it 
> > tripped an error to do with exceeding the index length.
> > 
> >     OperationalError: index row size 4684 exceeds maximum 2712 for index 
> > "doc_desc_doc_id_key"
> >     HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
> > 
> > 
> > 
> > Since the currently-provided input space is so large, but can technically 
> > accept only limited text, can we put a StaticText label atop this space
> > 
> > 
> >     Free text description (max 1/3 page)
> 
> The "page" relates to a buffer page inside PostgreSQL core
> code so that part wouldn't be helpful.
> 
> I shall drop the index itself (or rather constrain it to fk_doc only).

Done.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346