From: | David Scholes <david(at)cfourusa(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tuple Max Size on 7.1 |
Date: | 2001-05-02 22:48:41 |
Message-ID: | 3AF08EC9.BADC9E79@cfourusa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)scw(dot)org>
> Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-02 22:51:10 | Re: "group by" is quite expensive |
Previous Message | Tom Lane | 2001-05-02 22:44:12 | Re: Tuple Max Size on 7.1 |