Thread: Text Column limits
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.orgwww.hub.org1-902-542-3657-----------------------------------------------------
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
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.orgwww.hub.org1-902-542-3657-----------------------------------------------------
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
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.orgwww.hub.org1-902-542-3657-----------------------------------------------------
> 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