*** ./expected/inherit.out	Fri May  9 16:44:55 2008
--- ./results/inherit.out	Sat May 10 12:28:20 2008
***************
*** 846,855 ****
  drop table p1 cascade;
  NOTICE:  drop cascades to table c2
  NOTICE:  drop cascades to table c3
- NOTICE:  drop cascades to constraint p2_f2_check on table c3
- NOTICE:  drop cascades to constraint p2_f2_check on table c2
  NOTICE:  drop cascades to table c1
- NOTICE:  drop cascades to constraint p2_f2_check on table c1
  drop table p2 cascade;
  create table pp1 (f1 int);
  create table cc1 (f2 text, f3 int) inherits (pp1);
--- 846,852 ----
***************
*** 904,911 ****
  
  drop table pp1 cascade;
  NOTICE:  drop cascades to table cc2
- NOTICE:  drop cascades to constraint pp1_a1_check on table cc2
- NOTICE:  drop cascades to constraint pp1_a2_check on table cc2
  NOTICE:  drop cascades to table cc1
- NOTICE:  drop cascades to constraint pp1_a1_check on table cc1
- NOTICE:  drop cascades to constraint pp1_a2_check on table cc1
--- 901,904 ----

======================================================================

*** ./expected/create_view.out	Thu Feb  1 14:10:30 2007
--- ./results/create_view.out	Sat May 10 12:28:22 2008
***************
*** 238,261 ****
  
  DROP SCHEMA temp_view_test CASCADE;
  NOTICE:  drop cascades to view temp_view_test.v9
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v9
  NOTICE:  drop cascades to sequence temp_view_test.seq1
  NOTICE:  drop cascades to view temp_view_test.v8
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v8
  NOTICE:  drop cascades to view temp_view_test.v7
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v7
  NOTICE:  drop cascades to view temp_view_test.v6
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v6
  NOTICE:  drop cascades to view temp_view_test.v5
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v5
  NOTICE:  drop cascades to view temp_view_test.v4
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v4
  NOTICE:  drop cascades to view temp_view_test.v3
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v3
  NOTICE:  drop cascades to view temp_view_test.v2
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v2
  NOTICE:  drop cascades to view temp_view_test.v1
- NOTICE:  drop cascades to rule _RETURN on view temp_view_test.v1
  NOTICE:  drop cascades to table temp_view_test.base_table2
  NOTICE:  drop cascades to rule _RETURN on view v5_temp
  NOTICE:  drop cascades to view v5_temp
--- 238,252 ----
***************
*** 280,286 ****
  NOTICE:  drop cascades to view v10_temp
  DROP SCHEMA testviewschm2 CASCADE;
  NOTICE:  drop cascades to view pubview
- NOTICE:  drop cascades to rule _RETURN on view pubview
  NOTICE:  drop cascades to table tbl4
  NOTICE:  drop cascades to rule _RETURN on view mytempview
  NOTICE:  drop cascades to view mytempview
--- 271,276 ----
***************
*** 288,300 ****
  NOTICE:  drop cascades to table tbl2
  NOTICE:  drop cascades to table tbl1
  NOTICE:  drop cascades to view nontemp4
- NOTICE:  drop cascades to rule _RETURN on view nontemp4
  NOTICE:  drop cascades to view nontemp3
- NOTICE:  drop cascades to rule _RETURN on view nontemp3
  NOTICE:  drop cascades to view nontemp2
- NOTICE:  drop cascades to rule _RETURN on view nontemp2
  NOTICE:  drop cascades to view nontemp1
- NOTICE:  drop cascades to rule _RETURN on view nontemp1
  NOTICE:  drop cascades to table t2
  NOTICE:  drop cascades to table t1
  NOTICE:  drop cascades to rule _RETURN on view temporal4
--- 278,286 ----

======================================================================

*** ./expected/namespace.out	Sun Aug 20 20:57:26 2006
--- ./results/namespace.out	Sat May 10 12:28:43 2008
***************
*** 40,48 ****
  
  DROP SCHEMA test_schema_1 CASCADE;
  NOTICE:  drop cascades to view test_schema_1.abc_view
- NOTICE:  drop cascades to rule _RETURN on view test_schema_1.abc_view
  NOTICE:  drop cascades to table test_schema_1.abc
- NOTICE:  drop cascades to default for table test_schema_1.abc column a
  -- verify that the objects were dropped
  SELECT COUNT(*) FROM pg_class WHERE relnamespace =
      (SELECT oid FROM pg_namespace WHERE nspname = 'test_schema_1');
--- 40,46 ----

======================================================================

*** ./expected/alter_table.out	Fri May  9 13:19:56 2008
--- ./results/alter_table.out	Sat May 10 12:29:55 2008
***************
*** 376,382 ****
  
  drop table atacc2 cascade;
  NOTICE:  drop cascades to table atacc3
- NOTICE:  drop cascades to constraint foo on table atacc3
  drop table atacc1;
  -- adding only to a parent is disallowed as of 8.4
  create table atacc1 (test int);
--- 376,381 ----
***************
*** 1251,1257 ****
  
  drop table p1 cascade;
  NOTICE:  drop cascades to table c1
- NOTICE:  drop cascades to constraint p1_a1_check on table c1
  -- test that operations with a dropped column do not try to reference
  -- its datatype
  create domain mytype as text;
--- 1250,1255 ----
***************
*** 1474,1481 ****
  NOTICE:  drop cascades to type alter2.posint
  NOTICE:  drop cascades to function alter2.plus1(integer)
  NOTICE:  drop cascades to view alter2.v1
- NOTICE:  drop cascades to rule _RETURN on view alter2.v1
  NOTICE:  drop cascades to sequence alter2.t1_f1_seq
  NOTICE:  drop cascades to default for table alter2.t1 column f1
  NOTICE:  drop cascades to table alter2.t1
- NOTICE:  drop cascades to constraint t1_f2_check on table alter2.t1
--- 1472,1477 ----

======================================================================