| From: | pilsl(at)goldfisch(dot)at |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | 7.2.3: tuple is too big (max 8136) |
| Date: | 2002-11-01 13:33:48 |
| Message-ID: | 20021101143348.A7426@goldfisch.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
I got this error on older versions and was told to
upgrade. Unfortunately I run into the very same error with 7.2.3.
I have a table with 1600 cols (for testing) and insert one row into
it which results in this error:
$ psql -U peter -f /tmp/t
Password:
psql:/tmp/t:1: ERROR: Tuple is too big: size 19232, max size 8136
where /tmp/t is like:
insert into bigtable values ('testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest','testtest' .... and so on
I tried the same with a perl-program but as expected its exactely the same error.
I searched my whole systems for old libraries from a previous version
but I'm quite sure that my upgrade was quite a clean and successful
one...
thnx,
peter
--
mag. peter pilsl
IT-Consulting
tel: +43-699-1-3574035
fax: +43-699-4-3574035
pilsl(at)goldfisch(dot)at
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-11-01 13:50:54 | Re: 7.2.3: tuple is too big (max 8136) |
| Previous Message | Richard Huxton | 2002-11-01 12:37:42 | Re: SELECT Query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-11-01 13:50:54 | Re: 7.2.3: tuple is too big (max 8136) |
| Previous Message | Achilleus Mantzios | 2002-11-01 07:51:04 | Re: How do you write this query? |