Thanks Joel, the test you sent did work. So I assume the problem is in the
perl and odbc drivers that came with the PostgreSQL 7.1 RPM's. Are the
following RPM's up to date? postgresql-odbc-7.1-1.i386.rpm,
postgresql-perl-7.1-1.i386.rpm
test=# select version();
version
-----------------------------------------------------------
PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
test=# create table a ( f1 text );
CREATE
test=# insert into a select repeat('1234567890', 1000);
INSERT 1597272 1
test=# select length(f1) from a;
length
--------
10000
(1 row)
Joel Burton wrote:
> On Wed, 2 May 2001, David Scholes wrote:
>
> > When trying to do a large INSERT to a table in PostgreSQL 7.1, I get the
> > following error:
> > Tuple is too big: size 32112, max size 8140
> >
> > This limit is being hit both from Perl and Coldfusion. I am using the
> > drivers that came with the 7.1 distribution. We are running on RedHat
> > 7.0 and I used the RPM's to install.
> >
> > My understanding was that this limit was removed in 7.1. Any ideas?
>
> Hmm... are you *sure* this is 7.1? (SELECT version() will remove any
> doubt).
>
> Have you tried this w/psql, to isolate this from a Perl or
> ColdFusion problem?
>
> create table a ( f1 text );
>
> insert into a select ('1234567890', 1000);
>
> test=# select length(f1) from a;
>
> length
> --------
> 10000
>
> This will show if you can insert a 10000-char row.
>
> --
> Joel Burton <jburton@scw.org>
> Director of Information Systems, Support Center of Washington
