kill_obs_functions

kill_obs_functions.sql

CREATE OR REPLACE FUNCTION kill_obs_functions(
) RETURNS void
AS $$
DECLARE
  killselect TEXT;
BEGIN

FOR killselect in SELECT 'DROP FUNCTION ' || ns.nspname || '.' || proname || '(' ||
  oidvectortypes(proargtypes) || ');'
  FROM pg_proc
  JOIN pg_namespace ns ON (pg_proc.pronamespace = ns.oid)
  WHERE proname ilike 'obs_%' order by proname
LOOP
  raise notice '%', killselect;
  EXECUTE killselect;
END LOOP;

END;
$$ language plpgsql;