Re: DROP FUNCTION IF EXISTS

postgres=# drop type if exists foo;
NOTICE:  type "foo" does not exist, skipping
DROP TYPE
postgres=# drop table if exists foo;
NOTICE:  table "foo" does not exist, skipping
DROP TABLE
postgres=# drop function if exists foo();
NOTICE:  function foo() does not exist ... skipping
DROP FUNCTION
postgres=# drop function if exists foo(int);
NOTICE:  function foo(                     ^^^ here psql is stopped..


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/