Skip site navigation (1) Skip section navigation (2)

Re: var size too small?

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: Adam Bultman <adam(dot)bultman(at)iconideas(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: var size too small?
Date: 2001-11-09 17:32:43
Message-ID: 87y9lfc0jo.fsf@npa01zz001.simplot.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(dot)bultman(at)iconideas(dot)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

In response to

pgsql-novice by date

Next:From: Isaac SparrowDate: 2001-11-09 17:57:19
Subject: Re:
Previous:From: Jason EarlDate: 2001-11-09 17:30:47
Subject: Re: Benchmarking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group