Re: how to drop function? - Mailing list pgsql-general

From David Johnston
Subject Re: how to drop function?
Date
Msg-id B91E4089-6472-48CD-B852-F904D3E5B31D@yahoo.com
Whole thread Raw
In response to Re: how to drop function?  ("J.V." <jvsrvcs@gmail.com>)
List pgsql-general
On Nov 15, 2011, at 20:24, "J.V." <jvsrvcs@gmail.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.

pgsql-general by date:

Previous
From: "J.V."
Date:
Subject: Re: how to drop function?
Next
From: "J.V."
Date:
Subject: deferring pk constraint