*** ./expected/type_sanity.out	Thu Jan  4 10:52:38 2007
--- ./results/type_sanity.out	Wed Mar 28 09:21:35 2007
***************
*** 52,59 ****
  WHERE (p1.typtype = 'c' AND p1.typrelid = 0) OR
      (p1.typtype != 'c' AND p1.typrelid != 0);
   oid | typname 
! -----+---------
! (0 rows)
  
  -- Look for basic types that don't have an array type.
  -- NOTE: as of 8.0, this check finds smgr and unknown.
--- 52,201 ----
  WHERE (p1.typtype = 'c' AND p1.typrelid = 0) OR
      (p1.typtype != 'c' AND p1.typrelid != 0);
    oid  |              typname               
! -------+------------------------------------
!  10001 | _pg_autovacuum
!  10003 | _pg_attrdef
!  10005 | _pg_constraint
!  10007 | _pg_inherits
!  10009 | _pg_index
!  10011 | _pg_operator
!  10013 | _pg_opfamily
!  10015 | _pg_opclass
!  10118 | _pg_am
!  10120 | _pg_amop
!  10447 | _pg_amproc
!  10661 | _pg_language
!  10663 | _pg_largeobject
!  10665 | _pg_aggregate
!  10667 | _pg_statistic
!  10669 | _pg_rewrite
!  10671 | _pg_trigger
!  10673 | _pg_listener
!  10675 | _pg_description
!  10677 | _pg_cast
!  10944 | _pg_namespace
!  10946 | _pg_conversion
!  10948 | _pg_depend
!  10950 | _pg_database
!  10952 | _pg_tablespace
!  10954 | _pg_pltemplate
!  10956 | _pg_authid
!  10958 | _pg_auth_members
!  10960 | _pg_shdepend
!  10962 | _pg_shdescription
!  10977 | _pg_roles
!  10981 | _pg_shadow
!  10985 | _pg_group
!  10989 | _pg_user
!  10993 | _pg_rules
!  10998 | _pg_views
!  11002 | _pg_tables
!  11007 | _pg_indexes
!  11012 | _pg_stats
!  11017 | _pg_locks
!  11021 | _pg_cursors
!  11025 | _pg_prepared_xacts
!  11029 | _pg_prepared_statements
!  11033 | _pg_settings
!  11039 | _pg_timezone_abbrevs
!  11043 | _pg_timezone_names
!  11047 | _pg_stat_all_tables
!  11052 | _pg_stat_sys_tables
!  11056 | _pg_stat_user_tables
!  11060 | _pg_statio_all_tables
!  11065 | _pg_statio_sys_tables
!  11069 | _pg_statio_user_tables
!  11073 | _pg_stat_all_indexes
!  11078 | _pg_stat_sys_indexes
!  11082 | _pg_stat_user_indexes
!  11086 | _pg_statio_all_indexes
!  11091 | _pg_statio_sys_indexes
!  11095 | _pg_statio_user_indexes
!  11099 | _pg_statio_all_sequences
!  11103 | _pg_statio_sys_sequences
!  11107 | _pg_statio_user_sequences
!  11111 | _pg_stat_activity
!  11115 | _pg_stat_database
!  11521 | _sql_sizing
!  11527 | _sql_sizing_profiles
!  11366 | _information_schema_catalog_name
!  11371 | _applicable_roles
!  11375 | _administrable_role_authorizations
!  11379 | _attributes
!  11384 | _check_constraint_routine_usage
!  11388 | _check_constraints
!  11393 | _column_domain_usage
!  11398 | _column_privileges
!  11403 | _column_udt_usage
!  11408 | _columns
!  11413 | _constraint_column_usage
!  11418 | _constraint_table_usage
!  11422 | _domain_constraints
!  11426 | _domain_udt_usage
!  11430 | _domains
!  11435 | _enabled_roles
!  11439 | _key_column_usage
!  11444 | _parameters
!  11449 | _referential_constraints
!  11454 | _role_column_grants
!  11459 | _role_routine_grants
!  11464 | _role_table_grants
!  11469 | _role_usage_grants
!  11473 | _routine_privileges
!  11478 | _routines
!  11483 | _schemata
!  11487 | _sequences
!  11491 | _sql_features
!  11497 | _sql_implementation_info
!  11503 | _sql_languages
!  11509 | _sql_packages
!  11515 | _sql_parts
!  11533 | _table_constraints
!  11538 | _table_privileges
!  11543 | _tables
!  11548 | _triggered_update_columns
!  11552 | _triggers
!  11557 | _usage_privileges
!  11561 | _view_column_usage
!  11566 | _view_routine_usage
!  11571 | _view_table_usage
!  11576 | _views
!  11581 | _data_type_privileges
!  11586 | _element_types
!  16402 | _char_tbl
!  16411 | _float4_tbl
!  16414 | _float8_tbl
!  16417 | _int2_tbl
!  16420 | _varchar_tbl
!  16423 | _text_tbl
!  16429 | _int4_tbl
!  16434 | _int8_tbl
!  16470 | _num_data
!  16473 | _num_exp_add
!  16476 | _num_exp_sub
!  16479 | _num_exp_div
!  16482 | _num_exp_mul
!  16485 | _num_exp_sqrt
!  16488 | _num_exp_ln
!  16491 | _num_exp_log10
!  16494 | _num_exp_power_10_ln
!  16497 | _num_result
!  16523 | _num_input_test
!  16557 | _point_tbl
!  16560 | _lseg_tbl
!  16563 | _box_tbl
!  16566 | _path_tbl
!  16572 | _circle_tbl
!  16575 | _date_tbl
!  16578 | _time_tbl
!  16581 | _timetz_tbl
!  16584 | _polygon_tbl
!  16590 | _interval_tbl
!  16593 | _inet_tbl
!  16596 | _timestamptz_tbl
!  16599 | _reltime_tbl
!  16602 | _abstime_tbl
! (142 rows)
  
  -- Look for basic types that don't have an array type.
  -- NOTE: as of 8.0, this check finds smgr and unknown.

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

*** ./expected/alter_table.out	Wed Feb 14 09:36:34 2007
--- ./results/alter_table.out	Wed Mar 28 09:22:06 2007
***************
*** 1428,1433 ****
--- 1428,1438 ----
  alter type alter1.ctype set schema alter2;
  -- this should succeed because nothing is left in alter1
  drop schema alter1;
+ NOTICE:  type alter2.ctype[] depends on schema alter1
+ NOTICE:  type alter2.v1[] depends on schema alter1
+ NOTICE:  type alter2.t1[] depends on schema alter1
+ ERROR:  cannot drop schema alter1 because other objects depend on it
+ HINT:  Use DROP ... CASCADE to drop the dependent objects too.
  insert into alter2.t1(f2) values(13);
  insert into alter2.t1(f2) values(14);
  select * from alter2.t1;

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