Re: large text fields

Поиск
Список
Период
Сортировка
От Lamar Owen
Тема Re: large text fields
Дата
Msg-id 38ECF217.56C9392D@wgcr.org
обсуждение исходный текст
Ответ на large text fields  ("Kevin Heflin" <kheflin@shreve.net>)
Список pgsql-general
Kevin Heflin wrote:
>
> when ever I've dealt with a field that would require more text than 250
> characters, I've always used the 'text' datatype. It appears I've hit an
> example where this won't work. users are trying to insert what amounts to
> about 2 pages worth of text and I'm seeing this error:
>
> PostgresSQL query failed: ERROR: Tuple is too big: size 10000
>
> Are there any other options other than using a BLOB datatype ? which I'm
> completely unfamiliar with.

Recompile with a larger BLKSIZ of 16K or 32K. Or wait on TOAST.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

В списке pgsql-general по дате отправления:

Предыдущее
От: "Kevin Heflin"
Дата:
Сообщение: large text fields
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: Functions in postgres