Thread: text field size
1) Hi I am a novice in pgsql and I am trying to introduce a long text to one record... supposly text field size are unlimited but when I tried to insert the record the follow message appears : ERROR: Tuple is too big:size 10000, max size 8140 How I can fix this problem or what do you suggest to me? I appreciated your cooperation, Regards - Hector _________________________________________________________ Do You Yahoo!? Obtenga su dirección de correo-e gratis @yahoo.com en http://correo.espanol.yahoo.com
On Mon, 26 Feb 2001, [iso-8859-1] Hector Diaz wrote: > 1) Hi I am a novice in pgsql and I am trying to > introduce a long text to one record... supposly text > field size are unlimited but when I tried to insert > the record the follow message appears : > > ERROR: Tuple is too big:size 10000, max size 8140 > > How I can fix this problem or what do you suggest to > me? The nearest I can tell, no SQL dbase has unlimited size text fields. You need to rethink what it is you are storing. Perhaps you are stoing paragraphs, or sentences (for some definition of a paragraph or sentence: i.e. a sentence in English will be different than a sentence in the perl programming language). Gord Matter Realisations http://www.materialisations.com/ Gordon Haverland, B.Sc. M.Eng. President 101 9504 182 St. NW Edmonton, AB, CA T5T 3A7 780/481-8019 ghaverla @ freenet.edmonton.ab.ca 780/993-1274 (cell)
PostgreSQL 7.0.x har a row limit of 8KB, and your inserting 10KB :( PostgreSQL 7.1Beta does not have this limit :) Download the latest beta, or wait 2-4 weeks (roughly estimated!), when the stable version is released. The beta is quite stable, though. HTH, Poul L. Christiansen Hector Diaz wrote: > > 1) Hi I am a novice in pgsql and I am trying to > introduce a long text to one record... supposly text > field size are unlimited but when I tried to insert > the record the follow message appears : > > ERROR: Tuple is too big:size 10000, max size 8140 > > How I can fix this problem or what do you suggest to > me? > > I appreciated your cooperation, > > Regards > > - Hector > > _________________________________________________________ > Do You Yahoo!? > Obtenga su dirección de correo-e gratis @yahoo.com > en http://correo.espanol.yahoo.com
=?iso-8859-1?q?Hector=20Diaz?= wrote: >1) Hi I am a novice in pgsql and I am trying to >introduce a long text to one record... supposly text >field size are unlimited but when I tried to insert >the record the follow message appears : > >ERROR: Tuple is too big:size 10000, max size 8140 > >How I can fix this problem or what do you suggest to >me? Before PostgreSQL 7.1, there is a row size limit of about 8Kb. Upgrade to 7.1beta5, or use large objects, or rethink your application, or rebuild PostgreSQL with a larger row-limit and do an initdb to force the change into the database. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If we confess our sins, he is faithful and just to forgive us our sins, and to cleanse us from all unrighteousness." I John 1:9
Thanks to all you guys that bring me a wide number of options. I definitely will take the choice of install the 7.1beta version until the new one will be release. Do you know if 7.1 release version will include blob field to insert a binary data as graphics? if not, what other free database engine do you recommend that support it? and why? Kind Regards - Hector Diaz --- "Poul L. Christiansen" <poulc@cs.auc.dk> escribió: > PostgreSQL 7.0.x har a row limit of 8KB, and your > inserting 10KB :( > > PostgreSQL 7.1Beta does not have this limit :) > > Download the latest beta, or wait 2-4 weeks (roughly > estimated!), when > the stable version is released. The beta is quite > stable, though. > > HTH, > Poul L. Christiansen > > Hector Diaz wrote: > > > > 1) Hi I am a novice in pgsql and I am trying to > > introduce a long text to one record... supposly > text > > field size are unlimited but when I tried to > insert > > the record the follow message appears : > > > > ERROR: Tuple is too big:size 10000, max size 8140 > > > > How I can fix this problem or what do you suggest > to > > me? > > > > I appreciated your cooperation, > > > > Regards > > > > - Hector > > > > > _________________________________________________________ > > Do You Yahoo!? > > Obtenga su dirección de correo-e gratis @yahoo.com > > en http://correo.espanol.yahoo.com _________________________________________________________ Do You Yahoo!? Obtenga su dirección de correo-e gratis @yahoo.com en http://correo.espanol.yahoo.com