Thread

RE: [GENERAL] rules failed

Jackson, DeJuan <djackson@cpsgroup.com> — 1999-07-09T22:27:58Z

It looks like you're missing a couple of column AS column_new_name clauses
in your rules... What could cause this? I'm not sure maybe one of the big
guys could comments... Jan?
	-DEJ

> -----Original Message-----
> From:	Mike Engelhart [SMTP:mengelhart@earthtrip.com]
> Sent:	Friday, July 09, 1999 4:51 PM
> To:	pgsql-general@postgreSQL.org
> Subject:	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 ****
> 
> ! 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"))));
> --- 1066,1076 ----
> ! 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"))));
> ***************
> *** 1082,1088 ****
> ! 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";
> --- 1082,1088 ----
> ! 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";
> 
> ----------------------
> 
>