Strange error message with 7.0beta1
От | Kyle Bateman |
---|---|
Тема | Strange error message with 7.0beta1 |
Дата | |
Msg-id | 38C02452.128EE6B6@actarg.com обсуждение исходный текст |
Ответы |
Re: [SQL] Strange error message with 7.0beta1
(Peter Eisentraut <peter_e@gmx.net>)
|
Список | pgsql-sql |
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?
Вложения
В списке pgsql-sql по дате отправления: