
What is the default maximum limits for a text column, and how can I extend
it past those limits, if possible :>


 Chris Bowlby,
 -----------------------------------------------------
 Web Developer @ Hub.org.
 excalibur@hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------


Fri, 18 Jan 2002 15:59:33 -0400 (AST)
Chris Bowlby <excalibur@hub.org>
Text Column limits
Chris Bowlby <excalibur@hub.org> writes:

> What is the default maximum limits for a text column, and how can I extend
> it past those limits, if possible :>

The limit is very high in modern versions.  RAM + swap, basically.  ;)

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

18 Jan 2002 15:27:32 -0500
Doug McNaught <doug@wireboard.com>
Re: Text Column limits
On 18 Jan 2002, Doug McNaught wrote:

Hmmm,

 We've got a database that has about 81000 characters per text entry, of
which no more can be squeezed in....

> Chris Bowlby <excalibur@hub.org> writes:
>
> > What is the default maximum limits for a text column, and how can I extend
> > it past those limits, if possible :>
>
> The limit is very high in modern versions.  RAM + swap, basically.  ;)
>
> -Doug
> --
> Let us cross over the river, and rest under the shade of the trees.
>    --T. J. Jackson, 1863
>

 Chris Bowlby,
 -----------------------------------------------------
 Web Developer @ Hub.org.
 excalibur@hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------


Fri, 18 Jan 2002 17:02:36 -0400 (AST)
Chris Bowlby <excalibur@hub.org>
Re: Text Column limits
Chris Bowlby <excalibur@hub.org> writes:

> On 18 Jan 2002, Doug McNaught wrote:
> 
> Hmmm,
> 
>  We've got a database that has about 81000 characters per text entry, of
> which no more can be squeezed in....

And the error message you get is...  ???

We're not mind-readers here.  ;)

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

18 Jan 2002 16:05:18 -0500
Doug McNaught <doug@wireboard.com>
Re: Text Column limits
On 18 Jan 2002, Doug McNaught wrote:

Hi Doug,

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?


> Chris Bowlby <excalibur@hub.org> writes:
>
> > On 18 Jan 2002, Doug McNaught wrote:
> >
> > Hmmm,
> >
> >  We've got a database that has about 81000 characters per text entry, of
> > which no more can be squeezed in....
>
> And the error message you get is...  ???
>
> We're not mind-readers here.  ;)
>
> -Doug
> --
> Let us cross over the river, and rest under the shade of the trees.
>    --T. J. Jackson, 1863
>

 Chris Bowlby,
 -----------------------------------------------------
 Web Developer @ Hub.org.
 excalibur@hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------


Sun, 20 Jan 2002 23:56:03 -0400 (AST)
Chris Bowlby <excalibur@hub.org>
Re: Text Column limits
> 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


Mon, 21 Jan 2002 12:06:43 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Text Column limits