[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).
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346