Re: how to drop function?

On Nov 15, 2011, at 20:24, "J.V." <jvsrvcs(at)gmail(dot)com> wrote:

> this did not work.
>
> On 11/15/2011 4:56 PM, Craig Ringer wrote:
>> On 11/16/2011 07:38 AM, J.V. wrote:
>>> How do I drop a function that was created like so:
>>>
>>> create or replace function process_table (action TEXT, v_table_name
>>> varchar(100)) RETURNS BOOLEAN
>>> AS $$
>>> DECLARE
>>> ....
>>> BEGIN
>>> ...
>>> END;
>>> $$ LANGUAGE plpgsql;
>>>
>>> ---
>>> I have tried various ways, but it always fails.
>>
>> DROP FUNCTION process_table (action TEXT, v_table_name varchar(100));
>>
>> --
>> Craig Ringer
>>

If you are going to claim something doesn't work it really helps to provide the clues that lead you to that conclusion. Specifically, what error message(s) are you seeing?

The parameter names and the (100) are both optional so try removing them and see what happens.

David J.