Re: Storage limits in PostgreSQL?
От | Mitch Vincent |
---|---|
Тема | Re: Storage limits in PostgreSQL? |
Дата | |
Msg-id | 00ad01c0fd9b$71895e00$1251000a@Mitch обсуждение исходный текст |
Ответ на | Storage limits in PostgreSQL? (Frank Hilliard <frankhilliard@home.com>) |
Список | pgsql-general |
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) >
В списке pgsql-general по дате отправления: