Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP FUNCTION IF EXISTS - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: DROP FUNCTION IF EXISTS
Date
Msg-id 4517DC3E.205@sigaev.ru
Whole thread Raw
In response to Re: DROP FUNCTION IF EXISTS  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: DROP FUNCTION IF EXISTS  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Buildfarm alarms
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] large object regression tests