[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: Re: [Gnumed-bugs] Attach documents - limitation on input into free text document description
Date: Thu, 24 Nov 2011 10:06:00 +0100
User-agent: Mutt/1.5.21 (2010-09-15)

On Wed, Nov 23, 2011 at 10:28:18PM +0000, Jim Busser wrote:

> I tried pasting a consultation into the free text area of
>       Attach documents
> 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).

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]