-- -- Test RESTRICT and CASCADE keywords. -- -- Ensure system types cannot be removed DROP TYPE int4 CASCADE; ERROR: Drop Restricted as Type int4 is an essential for the database to function DROP FUNCTION nextval(text) CASCADE; ERROR: Drop Restricted as Function nextval is an essential for the database to function DROP TABLE pg_type CASCADE; ERROR: table "pg_type" is a system table -- Function RESTRICT / CASCADE DROP FUNCTION widget_in(opaque) RESTRICT; -- fail ERROR: Drop Restricted as Type widget Depends on Function widget_in DROP TYPE widget RESTRICT; -- fail ERROR: Drop Restricted as Operator <% Depends on Type widget DROP FUNCTION widget_in(opaque) CASCADE; NOTICE: Cascading drop to Type widget NOTICE: Cascading drop to Operator <% NOTICE: Cascading drop to Function pt_in_widget DROP TYPE widget RESTRICT; -- doesn't exist ERROR: Type "widget" does not exist -- Type RESTRICT / CASCADE DROP TYPE city_budget RESTRICT; -- fail ERROR: Drop Restricted as Table city Depends on Type city_budget DROP TYPE city_budget CASCADE; NOTICE: Cascading drop to Table city DROP TABLE city RESTRICT; -- doesn't exist ERROR: table "city" does not exist -- Domain RESTRICT / CASCADE DROP DOMAIN ddef1 RESTRICT; -- fail ERROR: Drop Restricted as Table defaulttest Depends on Type ddef1 DROP DOMAIN ddef1 CASCADE; NOTICE: Cascading drop to Table defaulttest DROP TABLE defaulttest RESTRICT; -- doesn't exist ERROR: table "defaulttest" does not exist -- Procedural languge RESTRICT / CASCADE DROP LANGUAGE plpgsql RESTRICT; -- fail ERROR: Drop Restricted as Function recursion_test Depends on PL Hander plpgsql DROP LANGUAGE plpgsql CASCADE; NOTICE: Cascading drop to Function recursion_test NOTICE: Cascading drop to Function wslot_slotlink_view NOTICE: Cascading drop to Function pslot_slotlink_view NOTICE: Cascading drop to Function pslot_backlink_view NOTICE: Cascading drop to Function tg_slotlink_unset NOTICE: Cascading drop to Function tg_slotlink_set NOTICE: Cascading drop to Function tg_slotlink_a NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_backlink_unset NOTICE: Cascading drop to Function tg_backlink_set NOTICE: Cascading drop to Function tg_backlink_a NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_phone_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_hslot_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_iface_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_pline_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_wslot_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_pslot_bu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_chkbacklink NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_chkslotlink NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_chkslotname NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_hslot_bd NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_hslot_biu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_hub_adjustslots NOTICE: Cascading drop to Function tg_hub_a NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_iface_biu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_system_au NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_pslot_biu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_pfield_ad NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_pfield_au NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_wslot_biu NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_room_ad NOTICE: Cascading drop to Trigger Unknown NOTICE: Cascading drop to Function tg_room_au NOTICE: Cascading drop to Trigger Unknown SELECT recursion_test(2,3); -- doesn't exist ERROR: Function 'recursion_test(int4, int4)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts -- Foreign Key RESTRICT / CASCADE -- See alter table pktable and fktable tests