From: Doug McNaught <doug@mcnaught.org>
To: pilsl@goldfisch.at
Cc: pgsql-general@postgresql.org
Subject: Re: 7.2.3: tuple is too big (max 8136)
Date: 03 Nov 2002 19:19:56 -0500
Message-ID: <m3adkq424z.fsf@varsoon.wireboard.com> (raw)
References: <20021101143348.A7426@goldfisch.at>
<m37kfx9z5t.fsf@varsoon.wireboard.com>
<20021104011105.A11131@goldfisch.at>
pilsl@goldfisch.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: doug@mcnaught.org, pilsl@goldfisch.at, pgsql-general@postgresql.org
Subject: Re: 7.2.3: tuple is too big (max 8136)
In-Reply-To: <m3adkq424z.fsf@varsoon.wireboard.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox