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

From Andrew Dunstan
Subject Re: DROP FUNCTION IF EXISTS
Date
Msg-id 4517E293.1090101@dunslane.net
Whole thread Raw
In response to Re: DROP FUNCTION IF EXISTS  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: DROP FUNCTION IF EXISTS  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DROP FUNCTION IF EXISTS  (Teodor Sigaev <teodor@sigaev.ru>)
List 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


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Release Notes: Major Changes in 8.2
Next
From: "Dave Page"
Date:
Subject: Re: Release Notes: Major Changes in 8.2