Thread: Storage limits in PostgreSQL?
I'm running into quite severe limits going into and out of PostgreSQL. At first I was getting the "text string is too long" error message in PostgreSQL. Then I upgraded to version 7.1 and that stopped. However, I still got it in Cold Fusion Linux. Today I tried a test block of text and measured where the cutoffs are. Here's the results: ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box. RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more accepted in box] UPDATE EMPTY text cell: RESULT: accepted [that is, it accepted 28,652 characters] QUERY cell with Cold Fusion RESULT: 7,995 characters displayed. Cold Fusion has an option called "Accept long text string" which is checked in CF administrator. I can also set the number of characters as high as 999,999. There can't be a low limit in the amount I can copy because I can copy over 700,000 characters locally. Any help or suggestions would be greatly appreciated. Frank Hilliard http://frankhilliard.com/
It sounds like you've ruled PostgreSQL as the problem. What web server and OS are you using? Do either impose any limits on the size of text boxes, the size of environment variables, etc.? Can you create a test form with a plain ColdFusion text box, submit it and have ColdFusion display what you typed in, having taken the database out of the equation? If a plain form works and phpPgAdmin doesn't, you might need to look more closely at phppgadmin. Frank Hilliard <frankhilliard%home.com@interlock.lexmark.com> on 06/25/2001 01:03:24 PM To: pgsql-general%postgresql.org@interlock.lexmark.com cc: (bcc: Wesley Sheldahl/Lex/Lexmark) Subject: [GENERAL] Storage limits in PostgreSQL? I'm running into quite severe limits going into and out of PostgreSQL. At first I was getting the "text string is too long" error message in PostgreSQL. Then I upgraded to version 7.1 and that stopped. However, I still got it in Cold Fusion Linux. Today I tried a test block of text and measured where the cutoffs are. Here's the results: ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box. RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more accepted in box] UPDATE EMPTY text cell: RESULT: accepted [that is, it accepted 28,652 characters] QUERY cell with Cold Fusion RESULT: 7,995 characters displayed. Cold Fusion has an option called "Accept long text string" which is checked in CF administrator. I can also set the number of characters as high as 999,999. There can't be a low limit in the amount I can copy because I can copy over 700,000 characters locally. Any help or suggestions would be greatly appreciated. Frank Hilliard http://frankhilliard.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Evidently the software you're using to connect to/interface with PostgreSQL have these limits, not PostgreSQL itself... The only thing that I see you can do is contact the authors of the software and inform them of the problem... -Mitch ---- Original Message ----- From: "Frank Hilliard" <frankhilliard@home.com> To: <pgsql-general@postgresql.org> Sent: Monday, June 25, 2001 1:03 PM Subject: [GENERAL] Storage limits in PostgreSQL? > I'm running into quite severe limits going into and out of PostgreSQL. > At first I was getting the "text string is too long" error message in > PostgreSQL. Then I upgraded to version 7.1 and that stopped. However, I > still got it in Cold Fusion Linux. Today I tried a test block of text > and measured where the cutoffs are. Here's the results: > > ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box. > > RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more > accepted in box] > UPDATE EMPTY text cell: > RESULT: accepted [that is, it accepted 28,652 characters] > QUERY cell with Cold Fusion > RESULT: 7,995 characters displayed. > > Cold Fusion has an option called "Accept long text string" which is > checked in CF administrator. I can also set the number of characters as > high as 999,999. There can't be a low limit in the amount I can copy > because > I can copy over 700,000 characters locally. > > Any help or suggestions would be greatly appreciated. > > Frank Hilliard > http://frankhilliard.com/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
On Monday 25 June 2001 13:03, Frank Hilliard wrote: > ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box. > RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more > accepted in box] > UPDATE EMPTY text cell: > RESULT: accepted [that is, it accepted 28,652 characters] Most browsers only accept 32K in a text box. Netscape for sure accepts no more than 32K. Plus, you have the webserver's POST limits to contend with. With a web-based system it is often easy to forget that many limitations are browser issues....I know I have forgotten about them in times past. Don't know about PHP's string processing limits for sure, but I don't think that's going to be an issue. > QUERY cell with Cold Fusion > RESULT: 7,995 characters displayed. Sounds like a ColdFusion interface problem. How is the interface to PostgreSQL handled? If in ODBC, is this the 7.1 ODBC driver? Is it an older client lib? > I can copy over 700,000 characters locally. Then it's a client issue. Go over each and every link in the system -- to test ODBC use some other client that can use ODBC to see what its limits are. Work your way back to each client, layer by layer, and see where that lossage comes from. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Lamar Owen wrote: >>ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box. >> > >>RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more >>accepted in box] >>UPDATE EMPTY text cell: >>RESULT: accepted [that is, it accepted 28,652 characters] >> > > Most browsers only accept 32K in a text box. Netscape for sure accepts no > more than 32K. Plus, you have the webserver's POST limits to contend with. > With a web-based system it is often easy to forget that many limitations are > browser issues....I know I have forgotten about them in times past. Something I do every know and again illustrates this perfectly: if I need to understand how a page is built I'll copy the page source code and paste it into a Dreamweaver page. Using Mozilla most pages have to be copy / pasted in at least two passes. 32 K is playing with the devil - I wouldn't try over 24. Makes designing web apps "fun". Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html