Received: from www.actarg.com (root@[209.180.91.25]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA78516 for ; Fri, 3 Mar 2000 15:42:50 -0500 (EST) (envelope-from kyle@actarg.com) Received: from actarg.com (root@tao.actarg.com [192.168.2.1]) by www.actarg.com (8.8.7/8.8.7) with ESMTP id NAA19378 for ; Fri, 3 Mar 2000 13:42:49 -0700 Received: from actarg.com (kyle@chi.actarg.com [192.168.2.16]) by actarg.com (8.8.7/8.8.7) with ESMTP id NAA20443 for ; Fri, 3 Mar 2000 13:40:46 -0700 Sender: kyle@actarg.com Message-ID: <38C02452.128EE6B6@actarg.com> Date: Fri, 03 Mar 2000 13:45:07 -0700 From: Kyle Bateman Organization: Action Target Inc X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Strange error message with 7.0beta1 Content-Type: multipart/mixed; boundary="------------088BCBC50835CC60A4F4E436" This is a multi-part message in MIME format. --------------088BCBC50835CC60A4F4E436 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When trying to load my data from a 6.5 pg_dump, I got the error message: psql:/tmp/ati-tmp.sql:87: ERROR: Tuple is too big: size 8164, max size 8140 I trimmed back the dump file to a minimum of these commands that will still generate the error: CREATE TABLE "exp_log" ( "expnum" text, "amount" float8, "tdate" date, "toid" int4, "pdto" text, "memo" text, "status" character varying(2), "etype" character varying(1), "glid" int4, "blink" int4); CREATE TABLE "whold_log" ( "expnum" text, "gross" float8, "fed" float8, "ssec" float8, "mcare" float8, "state" float8, "garn" float8, "med" float8, "dent" float8, "w125" float8, "w401k" float8, "eic" float8, "other" float8, "othacc" character varying, "cost" float8, "allow" int4, "taxstate" character varying(4)); CREATE TABLE "payroll_log" ( "expnum" text, "amount" float8, "tdate" date, "empl_id" int4, "pdto" text, "memo" text, "status" character varying(2), "glid" int4, "gross" float8, "fed" float8, "ssec" float8, "mcare" float8, "state" float8, "garn" float8, "med" float8, "dent" float8, "w125" float8, "w401k" float8, "eic" float8, "other" float8, "othacc" character varying, "cost" float8, "allow" int4, "taxstate" character varying(4)); CREATE RULE "_RETpayroll_log" AS ON SELECT TO "payroll_log" DO INSTEAD SELECT "e"."expnum", "e"."amount", "e"."tdate", "e"."toid" AS "empl_id", "e"."pdto", "e"."memo", "e"."status", "e"."glid", "w"."gross", "w"."fed", "w"."ssec", "w"."mcare", "w"."state", "w"."garn", "w"."med", "w"."dent", "w"."w125", "w"."w401k", "w"."eic", "w"."other", "w"."othacc", "w"."cost", "w"."allow", "w"."taxstate" FROM "exp_log" "e", "whold_log" "w" WHERE ("e"."etype" = 'p'::"varchar") AND ("e"."expnum" = "w"."expnum"); As the SQL was generated by a previous copy of PostgreSQL, I figured it might be a problem with the 7.0beta1. Any ideas? --------------088BCBC50835CC60A4F4E436 Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Bateman Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle tel;fax:801-377-8096 tel;work:801-377-8033x101 x-mozilla-html:FALSE url:www.actiontarget.com org:Action Target Inc adr:;;PO Box 636;Provo;UT;84603;US version:2.1 email;internet:kyle@actiontarget.com title:President x-mozilla-cpt:;-15520 fn:Kyle Bateman end:vcard --------------088BCBC50835CC60A4F4E436--