Re: Text Column limits

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Chris Bowlby" <excalibur(at)hub(dot)org>, "Doug McNaught" <doug(at)wireboard(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Text Column limits
Date: 2002-01-21 04:06:43
Message-ID: GNELIHDDFBOCMGBFGEFOIEBOCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-01-21 04:43:53 Re: [HACKERS] PostgreSQL Licence: GNU/GPL
Previous Message Chris Bowlby 2002-01-21 03:56:03 Re: Text Column limits