Re: DROP FUNCTION IF EXISTS

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP FUNCTION IF EXISTS
Date: 2006-09-25 13:40:14
Message-ID: 4517DC3E.205@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-09-25 13:44:21 Re: [PATCHES] large object regression tests
Previous Message Dave Page 2006-09-25 13:23:39 Re: Buildfarm alarms