Thread: Tuple too big ?

Howdy:

Question -

I'm running Postgres 7.1.3 on Mandrake Linux 8.0,
kernel version 2.4.16.

I have an sql script that does the following:

[script]
drop table t_bp_measure;
drop sequence t_bp_measure_seq;

create sequence t_bp_measure_seq;

create table t_bp_measure as
(select distinct
nextval ('t_bp_measure_seq') as t_bp_measure_id,
a.type as bp_measure_type,
c.label as bp_measure_label
from sys_dates a, sys_types c
);

[/script]

It has taken about 3 hours to do anything useful and
the error returns:

[error]

[shaunn@hmp makes]$ psql -U web -d bcn -f ./make.bp_measure
psql:./make.bp_measure:7: ERROR:  table "t_bp_measure" does not exist
DROP
CREATE
psql:./make.bp_measure:30: ERROR:  Tuple is too big: size 3866620, max size 8136
psql:./make.bp_measure:36: ERROR:  Relation 't_bp_measure' does not exist

[/error]

I'm not sure as to what this is referring to.  I know I can do
each line separately and get the desired results, but at
this point, I'm not sure what's going on in the above statements;
If I do an 'explain', I am told about how much time was going to be
spent on each part ... but I can't see how that's helpful.  I am
new to the entire Postgres experience ... (the 'explain' sql is
probably a red herring ... probably nothing related to the error).

Thanks!

-X

--Thanks for the reply.

--Actually, I believe so.

[snip]

[shaunn@hmp shaunn]$ rpm -qa | grep -i postgr
postgresql-7.0.3-12mdk
postgresql-tcl-7.0.3-12mdk
postgresql-server-7.0.3-12mdk

[/snip]

--I imagine upgrading the tools would help.

--Thanks again.

-X

-----Original Message-----
From: Justin Clift [mailto:justin@postgresql.org]
Sent: Saturday, January 05, 2002 12:20 PM
To: Johnson, Shaunn
Subject: Re: [GENERAL] Tuple too big ?

Hi Shaunn,

It sounds like some of the PostgreSQL utilities you're using might be
out of date.

The "tuple too big" error, with a size of 8136, was from versions of
PostgreSQL prior to the 7.1.x series.  Are you sure there aren't still
any RPM's or installed PostgreSQL utilities around from older versions?

:-)

Regards and best wishes,

Justin Clift

> "Johnson, Shaunn" wrote:
>
> Howdy:
>
> Question -
>
> I'm running Postgres 7.1.3 on Mandrake Linux 8.0,
> kernel version 2.4.16.
>
> I have an sql script that does the following:
>
> [script]
> drop table t_bp_measure;
> drop sequence t_bp_measure_seq;
>
> create sequence t_bp_measure_seq;
>
> create table t_bp_measure as
> (select distinct
> nextval ('t_bp_measure_seq') as t_bp_measure_id,
> a.type as bp_measure_type,
> c.label as bp_measure_label
> from sys_dates a, sys_types c
> );
>
> [/script]
>
> It has taken about 3 hours to do anything useful and
> the error returns:
>
> [error]
>
> [shaunn@hmp makes]$ psql -U web -d bcn -f ./make.bp_measure
> psql:./make.bp_measure:7: ERROR:  table "t_bp_measure" does not exist
> DROP
> CREATE
> psql:./make.bp_measure:30: ERROR:  Tuple is too big: size 3866620, max
> size 8136
> psql:./make.bp_measure:36: ERROR:  Relation 't_bp_measure' does not
> exist
>
> [/error]
>
> I'm not sure as to what this is referring to.  I know I can do
> each line separately and get the desired results, but at
> this point, I'm not sure what's going on in the above statements;
> If I do an 'explain', I am told about how much time was going to be
> spent on each part ... but I can't see how that's helpful.  I am
> new to the entire Postgres experience ... (the 'explain' sql is
> probably a red herring ... probably nothing related to the error).
>
> Thanks!
>
> -X

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi