--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
