Re: [GENERAL] rules failed

> What did regression.diff tell you?
> I'm sure someone can give you more insight with that diff information.
>  -DEJ

well here is the relevant part from regression.diffs, but I don't understand
what it's supposed to be telling me...
Thanks,
Mike


*** expected/rules.out Thu Jun  3 02:01:21 1999
--- results/rules.out Fri Jul  9 14:04:16 1999
***************
*** 1066,1076 ****

  QUERY: SELECT viewname, definition FROM pg_views ORDER BY viewname;
  viewname          |definition
!
------------------+---------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------------------------------
  iexit             |SELECT "ih"."name", "ih"."thepath",
"interpt_pp"("ih"."thepath", "r"."thepath") AS "exit" FROM "ihighway" "ih",
"ramp" "r" WHERE "ih"."thepath" ## "r"."thepath";
  pg_indexes        |SELECT "c"."relname" AS "tablename", "i"."relname" AS
"indexname", "pg_get_indexdef"("x"."indexrelid") AS "indexdef" FROM
"pg_index" "x", "pg_class" "c", "pg_class" "i" WHERE ("c"."oid" =
"x"."indrelid") AND ("i"."oid" = "x"."indexrelid");
  pg_rules          |SELECT "c"."relname" AS "tablename", "r"."rulename",
"pg_get_ruledef"("r"."rulename") AS "definition" FROM "pg_rewrite" "r",
"pg_class" "c" WHERE ("r"."rulename" !~ '^_RET'::"text") AND ("c"."oid" =
"r"."ev_class");
! pg_tables         |SELECT "c"."relname" AS "tablename",
"pg_get_userbyid"("c"."relowner") AS "tableowner", "c"."relhasindex" AS
"hasindexes", "c"."relhasrules" AS "hasrules", "c"."reltriggers" >
'0'::"int4" AS "hastriggers" FROM "pg_class" "c" WHERE (("c"."relkind" =
'r'::"char") OR ("c"."relkind" = 's'::"char")) AND (NOT (EXISTS (SELECT
"rulename" FROM "pg_rewrite" WHERE ("ev_class" = "c"."oid") AND ("ev_type" =
'1'::"char"))));
  pg_user           |SELECT "usename", "usesysid", "usecreatedb",
"usetrace", "usesuper", "usecatupd", '********'::"text" AS "passwd",
"valuntil" FROM "pg_shadow";
  pg_views          |SELECT "c"."relname" AS "viewname",
"pg_get_userbyid"("c"."relowner") AS "viewowner",
"pg_get_viewdef"("c"."relname") AS "definition" FROM "pg_class" "c" WHERE
("c"."relhasrules") AND (EXISTS (SELECT "r"."rulename" FROM "pg_rewrite" "r"
WHERE ("r"."ev_class" = "c"."oid") AND ("r"."ev_type" = '1'::"char")));
  rtest_v1          |SELECT "a", "b" FROM "rtest_t1";
--- 1066,1076 ----

  QUERY: SELECT viewname, definition FROM pg_views ORDER BY viewname;
  viewname          |definition
!
------------------+---------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------
  iexit             |SELECT "ih"."name", "ih"."thepath",
"interpt_pp"("ih"."thepath", "r"."thepath") AS "exit" FROM "ihighway" "ih",
"ramp" "r" WHERE "ih"."thepath" ## "r"."thepath";
  pg_indexes        |SELECT "c"."relname" AS "tablename", "i"."relname" AS
"indexname", "pg_get_indexdef"("x"."indexrelid") AS "indexdef" FROM
"pg_index" "x", "pg_class" "c", "pg_class" "i" WHERE ("c"."oid" =
"x"."indrelid") AND ("i"."oid" = "x"."indexrelid");
  pg_rules          |SELECT "c"."relname" AS "tablename", "r"."rulename",
"pg_get_ruledef"("r"."rulename") AS "definition" FROM "pg_rewrite" "r",
"pg_class" "c" WHERE ("r"."rulename" !~ '^_RET'::"text") AND ("c"."oid" =
"r"."ev_class");
! pg_tables         |SELECT "c"."relname" AS "tablename",
"pg_get_userbyid"("c"."relowner"), "c"."relhasindex" AS "hasindexes",
"c"."relhasrules" AS "hasrules", "c"."reltriggers" > '0'::"int4" AS
"hastriggers" FROM "pg_class" "c" WHERE (("c"."relkind" = 'r'::"char") OR
("c"."relkind" = 's'::"char")) AND (NOT (EXISTS (SELECT "rulename" FROM
"pg_rewrite" WHERE ("ev_class" = "c"."oid") AND ("ev_type" =
'1'::"char"))));
  pg_user           |SELECT "usename", "usesysid", "usecreatedb",
"usetrace", "usesuper", "usecatupd", '********'::"text" AS "passwd",
"valuntil" FROM "pg_shadow";
  pg_views          |SELECT "c"."relname" AS "viewname",
"pg_get_userbyid"("c"."relowner") AS "viewowner",
"pg_get_viewdef"("c"."relname") AS "definition" FROM "pg_class" "c" WHERE
("c"."relhasrules") AND (EXISTS (SELECT "r"."rulename" FROM "pg_rewrite" "r"
WHERE ("r"."ev_class" = "c"."oid") AND ("r"."ev_type" = '1'::"char")));
  rtest_v1          |SELECT "a", "b" FROM "rtest_t1";
***************
*** 1082,1088 ****
  rtest_vview5      |SELECT "a", "b", "rtest_viewfunc1"("a") AS "refcount"
FROM "rtest_view1";
  shoe              |SELECT "sh"."shoename", "sh"."sh_avail",
"sh"."slcolor", "sh"."slminlen", "sh"."slminlen" * "un"."un_fact" AS
"slminlen_cm", "sh"."slmaxlen", "sh"."slmaxlen" * "un"."un_fact" AS
"slmaxlen_cm", "sh"."slunit" FROM "shoe_data" "sh", "unit" "un" WHERE
"sh"."slunit" = "un"."un_name";
  shoe_ready        |SELECT "rsh"."shoename", "rsh"."sh_avail",
"rsl"."sl_name", "rsl"."sl_avail", "int4smaller"("rsh"."sh_avail",
"rsl"."sl_avail") AS "total_avail" FROM "shoe" "rsh", "shoelace" "rsl" WHERE
(("rsl"."sl_color" = "rsh"."slcolor") AND ("rsl"."sl_len_cm" >=
"rsh"."slminlen_cm")) AND ("rsl"."sl_len_cm" <= "rsh"."slmaxlen_cm");
! shoelace          |SELECT "s"."sl_name", "s"."sl_avail", "s"."sl_color",
"s"."sl_len", "s"."sl_unit", "s"."sl_len" * "u"."un_fact" AS "sl_len_cm"
FROM "shoelace_data" "s", "unit" "u" WHERE "s"."sl_unit" = "u"."un_name";
  shoelace_candelete|SELECT "sl_name", "sl_avail", "sl_color", "sl_len",
"sl_unit", "sl_len_cm" FROM "shoelace_obsolete" WHERE "sl_avail" =
'0'::"int4";
  shoelace_obsolete |SELECT "sl_name", "sl_avail", "sl_color", "sl_len",
"sl_unit", "sl_len_cm" FROM "shoelace" WHERE NOT (EXISTS (SELECT "shoename"
FROM "shoe" WHERE "slcolor" = "sl_color"));
  street            |SELECT "r"."name", "r"."thepath", "c"."cname" FROM
"road" "r", "real_city" "c" WHERE "c"."outline" ## "r"."thepath";
--- 1082,1088 ----
  rtest_vview5      |SELECT "a", "b", "rtest_viewfunc1"("a") AS "refcount"
FROM "rtest_view1";
  shoe              |SELECT "sh"."shoename", "sh"."sh_avail",
"sh"."slcolor", "sh"."slminlen", "sh"."slminlen" * "un"."un_fact" AS
"slminlen_cm", "sh"."slmaxlen", "sh"."slmaxlen" * "un"."un_fact" AS
"slmaxlen_cm", "sh"."slunit" FROM "shoe_data" "sh", "unit" "un" WHERE
"sh"."slunit" = "un"."un_name";
  shoe_ready        |SELECT "rsh"."shoename", "rsh"."sh_avail",
"rsl"."sl_name", "rsl"."sl_avail", "int4smaller"("rsh"."sh_avail",
"rsl"."sl_avail") AS "total_avail" FROM "shoe" "rsh", "shoelace" "rsl" WHERE
(("rsl"."sl_color" = "rsh"."slcolor") AND ("rsl"."sl_len_cm" >=
"rsh"."slminlen_cm")) AND ("rsl"."sl_len_cm" <= "rsh"."slmaxlen_cm");
! shoelace          |SELECT "s"."sl_name", "s"."sl_avail", "s"."sl_color",
"s"."sl_len", "s"."sl_unit", "s"."sl_len" * "u"."un_fact" FROM
"shoelace_data" "s", "unit" "u" WHERE "s"."sl_unit" = "u"."un_name";
  shoelace_candelete|SELECT "sl_name", "sl_avail", "sl_color", "sl_len",
"sl_unit", "sl_len_cm" FROM "shoelace_obsolete" WHERE "sl_avail" =
'0'::"int4";
  shoelace_obsolete |SELECT "sl_name", "sl_avail", "sl_color", "sl_len",
"sl_unit", "sl_len_cm" FROM "shoelace" WHERE NOT (EXISTS (SELECT "shoename"
FROM "shoe" WHERE "slcolor" = "sl_color"));
  street            |SELECT "r"."name", "r"."thepath", "c"."cname" FROM
"road" "r", "real_city" "c" WHERE "c"."outline" ## "r"."thepath";

----------------------