Re: 7.2.3: tuple is too big (max 8136)

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: pilsl(at)goldfisch(dot)at
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2.3: tuple is too big (max 8136)
Date: 2002-11-04 00:19:56
Message-ID: m3adkq424z.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

pilsl(at)goldfisch(dot)at writes:

> On Fri, Nov 01, 2002 at 08:50:54AM -0500, Doug McNaught wrote:
> >
> > It's possible you are hitting the maximum column limit rather than the
> > tuple size limit. The FAQ list the max columns in a table as:
> >
> > "250-1600 depending on column types"
> >
>
> I already created the table with 1600 cols of varchar(30) so this
> should not be the limit. And the errormessage is clearly talking about
> the tuples size. (which should not have such a limit in 7.2.3).

Well, it does say "depending on column type". Perhaps it is giving a
valid error but the wrong message. The 8k tuple-size limit is
definitely gone in modern versions of PG (since 7.1 I believe) so I
don't see why that error message should appear.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-11-04 00:21:31 OT : Anyone know what's happened to Gandi.net?
Previous Message pilsl 2002-11-04 00:11:06 Re: 7.2.3: tuple is too big (max 8136)

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-11-04 00:38:45 Re: 7.2.3: tuple is too big (max 8136)
Previous Message pilsl 2002-11-04 00:11:06 Re: 7.2.3: tuple is too big (max 8136)