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/