Strange error message with 7.0beta1 - Mailing list pgsql-sql

From Kyle Bateman
Subject Strange error message with 7.0beta1
Date
Msg-id 38C02452.128EE6B6@actarg.com
Whole thread Raw
Responses Re: [SQL] Strange error message with 7.0beta1
List 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?

Attachment

pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: 7.0beta bug (or feature)?
Next
From: Kyle Bateman
Date:
Subject: ENUM Type