| 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: | Whole Thread | Raw Message | 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
| 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 |