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.org
www.hub.org
1-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
Import Notes
Reply to msg id not found: ChrisBowlbysmessageofFri18Jan2002155933-0400AST
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
-----------------------------------------------------
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
Import Notes
Reply to msg id not found: ChrisBowlbysmessageofFri18Jan2002170236-0400AST
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
-----------------------------------------------------
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