| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz>, "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com> |
| Subject: | Re: how to drop function? |
| Date: | 2011-11-16 00:08:04 |
| Message-ID: | 201111151608.04483.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday, November 15, 2011 3:56:32 pm Rebecca Clarke wrote:
> DROP FUNCTION process_table;
>
> should work.
>
Actually no, for the following reason:(
http://www.postgresql.org/docs/9.0/interactive/sql-dropfunction.html
"DROP FUNCTION removes the definition of an existing function. To execute this
command the user must be the owner of the function. The argument types to the
function must be specified, since several different functions can exist with the
same name and different argument lists"
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.V. | 2011-11-16 01:24:12 | Re: how to drop function? |
| Previous Message | Ivan Sergio Borgonovo | 2011-11-16 00:01:31 | Re: how to drop function? |