Re: DROP FUNCTION IF EXISTS

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

Teodor Sigaev wrote:
> 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..
>
>

Yes, this appears to be a bug, not related to encoding etc. Maybe we
should be calling func_signature_string in generating this error.

I will look at it when I get a chance, might be a few days.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-09-25 14:10:39 Re: Release Notes: Major Changes in 8.2
Previous Message Jim C. Nasby 2006-09-25 14:02:51 Re: Release Notes: Major Changes in 8.2