Hi, CREATE FUNCTION checks properly for the existance of referred schemas.
Eg CREATE FUNCTION current_date_id(timestamp) returns integer AS 'SELECT date_id from general.date_dimension where sql_date=date($1)' language 'SQL';ERROR: Namespace "general" does not exist but DROP SCHEMA does not check that some function could depend on a table that is potentially getting dropped. If such functions remains even when corresponding schemas are dropped they do not pass the dump restore cycle. Even if the schema are not dropped pg_dump [ 7.4dev ] dumps out these functions before the SCHEMA creation hence restore fails. regds Mallah. ----------------------------------------- Over 1,00,000 exporters are waiting for your order! Click below to get in touch with leading Indian exporters listed in the premier trade directory Exporters Yellow Pages. http://www.trade-india.com/dyn/gdh/eyp/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
