Re: Text Column limits - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Text Column limits
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEBOCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Text Column limits  (Chris Bowlby <excalibur@hub.org>)
List pgsql-hackers
> Ack.. sorry about that... ok here's the error...
>
> ERROR:  Tuple is too big: size 14392, max size 8140
>
> looks like the size is being restricted to about 8K, when I need to sqeeze
> 14+K into her.... did we miss a compile option somewhere?

Just make sure you're using postgres 7.1.x, and have recompiled any software
(such as PHP) that links to it and you will have a virtually unlimited row
length.  (Use 'text' column type for text and 'bytea' for binary)

Chris



pgsql-hackers by date:

Previous
From: Chris Bowlby
Date:
Subject: Re: Text Column limits
Next
From: mlw
Date:
Subject: Re: PostgreSQL Licence: GNU/GPL