Обсуждение: var size too small?

Поиск
Список
Период
Сортировка

var size too small?

От
Adam Bultman
Дата:
Hey everyone. I'm a bit of a lurker, but I've got a question:

We've got a database with a table with items of type "var" in them, and
it seems that it's not unlimited, but rather, about 8k.  Is there a way
to fix this without switching to a recent beta version? Is there a work
around?



--
Adam Bultman
Icon Multimedia
616-836-7213

Re: var size too small?

От
Francisco Reyes
Дата:
On Thu, 8 Nov 2001, Adam Bultman wrote:

> We've got a database with a table with items of type "var" in them, and
> it seems that it's not unlimited, but rather, about 8k.  Is there a way
> to fix this without switching to a recent beta version? Is there a work
> around?

I am a newbie myself, but my understanding is that for larger columns you
use other data types such as Text.

Check http://www.postgresql.org/idocs/index.php?datatype.html

Re: var size too small?

От
Jason Earl
Дата:
What version of PostgreSQL.  Before 7.1 PostgreSQL had a row limit of
8K.  This could be increased to 32K, but only by recompiling
PostgreSQL.  Newer versions don't have this limitation.

Jason

Adam Bultman <adam.bultman@iconideas.com> writes:

> Hey everyone. I'm a bit of a lurker, but I've got a question:
>
> We've got a database with a table with items of type "var" in them, and
> it seems that it's not unlimited, but rather, about 8k.  Is there a way
> to fix this without switching to a recent beta version? Is there a work
> around?
>
>
>
> --
> Adam Bultman
> Icon Multimedia
> 616-836-7213
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html