pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Strange error message with 7.0beta1
3+ messages / 3 participants
[nested] [flat]

* Strange error message with 7.0beta1
@ 2000-03-03 20:45 Kyle Bateman <kyle@actarg.com>
  2000-03-04 17:05 ` Re: [SQL] Strange error message with 7.0beta1 Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Kyle Bateman @ 2000-03-03 20:45 UTC (permalink / raw)
  To: 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?

Attachments:

kyle.vcf (text/x-vcard, 290B) download 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
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: [SQL] Strange error message with 7.0beta1
  2000-03-03 20:45 Strange error message with 7.0beta1 Kyle Bateman <kyle@actarg.com>
@ 2000-03-04 17:05 ` Peter Eisentraut <peter_e@gmx.net>
  2000-03-07 23:23   ` Re: [SQL] Strange error message with 7.0beta1 Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2000-03-04 17:05 UTC (permalink / raw)
  To: Kyle Bateman <kyle@actarg.com>; +Cc: pgsql-sql

Kyle Bateman writes:

> 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

> CREATE TABLE "exp_log" (

> CREATE TABLE "whold_log" (

> CREATE TABLE "payroll_log" (

> CREATE RULE "_RETpayroll_log" AS
>         ON SELECT TO "payroll_log"
>         DO INSTEAD
>         SELECT  "e"."expnum",
[ a lot ]
>         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.

Due to some internal changes the rule descriptor (so to speak) has
expanded in its size so now it doesn't fit within a tuple anymore. There
were some changes done in this area just the other day, so you might want
to get a later beta and try it out. (I think they make these every night.)

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Strange error message with 7.0beta1
  2000-03-03 20:45 Strange error message with 7.0beta1 Kyle Bateman <kyle@actarg.com>
  2000-03-04 17:05 ` Re: [SQL] Strange error message with 7.0beta1 Peter Eisentraut <peter_e@gmx.net>
@ 2000-03-07 23:23   ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2000-03-07 23:23 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Kyle Bateman <kyle@actarg.com>; pgsql-sql

> 
> Due to some internal changes the rule descriptor (so to speak) has
> expanded in its size so now it doesn't fit within a tuple anymore. There
> were some changes done in this area just the other day, so you might want
> to get a later beta and try it out. (I think they make these every night.)
> 

Get the snapshot, not beta1.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-03-07 23:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-03-03 20:45 Strange error message with 7.0beta1 Kyle Bateman <kyle@actarg.com>
2000-03-04 17:05 ` Peter Eisentraut <peter_e@gmx.net>
2000-03-07 23:23   ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox