*** ./expected/opr_sanity.out Sun Jun 22 18:07:13 2003 --- ./results/opr_sanity.out Sun Jul 27 01:37:24 2003 *************** *** 85,92 **** p1.provolatile != p2.provolatile OR p1.pronargs != p2.pronargs); oid | proname | oid | proname ! -----+---------+-----+--------- ! (0 rows) -- Look for uses of different type OIDs in the argument/result type fields -- for different aliases of the same built-in function. --- 85,104 ---- p1.provolatile != p2.provolatile OR p1.pronargs != p2.pronargs); oid | proname | oid | proname ! ------+----------------------+------+---------------------- ! 2504 | pg_get_ruledef | 1573 | pg_get_ruledef ! 2505 | pg_get_viewdef | 1640 | pg_get_viewdef ! 2506 | pg_get_viewdef | 1641 | pg_get_viewdef ! 2507 | pg_get_indexdef | 1643 | pg_get_indexdef ! 2508 | pg_get_constraintdef | 1387 | pg_get_constraintdef ! 2509 | pg_get_expr | 1716 | pg_get_expr ! 1716 | pg_get_expr | 2509 | pg_get_expr ! 1573 | pg_get_ruledef | 2504 | pg_get_ruledef ! 1640 | pg_get_viewdef | 2505 | pg_get_viewdef ! 1641 | pg_get_viewdef | 2506 | pg_get_viewdef ! 1643 | pg_get_indexdef | 2507 | pg_get_indexdef ! 1387 | pg_get_constraintdef | 2508 | pg_get_constraintdef ! (12 rows) -- Look for uses of different type OIDs in the argument/result type fields -- for different aliases of the same built-in function. *************** *** 136,147 **** (p1.proargtypes[1] < p2.proargtypes[1]); proargtypes | proargtypes -------------+------------- 23 | 28 25 | 1042 1114 | 1184 1560 | 1562 2277 | 2283 ! (5 rows) SELECT DISTINCT p1.proargtypes[2], p2.proargtypes[2] FROM pg_proc AS p1, pg_proc AS p2 --- 148,161 ---- (p1.proargtypes[1] < p2.proargtypes[1]); proargtypes | proargtypes -------------+------------- + 0 | 16 + 0 | 23 23 | 28 25 | 1042 1114 | 1184 1560 | 1562 2277 | 2283 ! (7 rows) SELECT DISTINCT p1.proargtypes[2], p2.proargtypes[2] FROM pg_proc AS p1, pg_proc AS p2 *************** *** 152,159 **** (p1.proargtypes[2] < p2.proargtypes[2]); proargtypes | proargtypes -------------+------------- 1114 | 1184 ! (1 row) SELECT DISTINCT p1.proargtypes[3], p2.proargtypes[3] FROM pg_proc AS p1, pg_proc AS p2 --- 166,174 ---- (p1.proargtypes[2] < p2.proargtypes[2]); proargtypes | proargtypes -------------+------------- + 0 | 16 1114 | 1184 ! (2 rows) SELECT DISTINCT p1.proargtypes[3], p2.proargtypes[3] FROM pg_proc AS p1, pg_proc AS p2 ====================================================================== *** ./expected/rules.out Sun Jul 27 00:26:06 2003 --- ./results/rules.out Sun Jul 27 01:37:42 2003 *************** *** 1314,1320 **** SELECT tablename, rulename, definition FROM pg_rules ORDER BY tablename, rulename; tablename | rulename | definition ! ---------------+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- pg_settings | pg_settings_n | CREATE RULE pg_settings_n AS ON UPDATE TO pg_settings DO INSTEAD NOTHING; pg_settings | pg_settings_u | CREATE RULE pg_settings_u AS ON UPDATE TO pg_settings WHERE (new.name = old.name) DO SELECT set_config(old.name, new.setting, false) AS set_config; rtest_emp | rtest_emp_del | CREATE RULE rtest_emp_del AS ON DELETE TO rtest_emp DO INSERT INTO rtest_emplog (ename, who, "action", newsal, oldsal) VALUES (old.ename, "current_user"(), 'fired'::bpchar, '$0.00'::money, old.salary); --- 1314,1320 ---- SELECT tablename, rulename, definition FROM pg_rules ORDER BY tablename, rulename; tablename | rulename | definition ! ---------------+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ pg_settings | pg_settings_n | CREATE RULE pg_settings_n ASON UPDATE TO pg_settings DO INSTEAD NOTHING; pg_settings | pg_settings_u | CREATE RULE pg_settings_u ASON UPDATE TO pg_settings WHERE (new.name = old.name) DO SELECT set_config(old.name, new.setting, false) AS set_config; rtest_emp | rtest_emp_del | CREATE RULE rtest_emp_del ASON DELETE TO rtest_emp DO INSERT INTO rtest_emplog (ename, who, "action", newsal, oldsal) VALUES (old.ename, "current_user"(), 'fired'::bpchar, '$0.00'::money, old.salary); ======================================================================