Re: how to drop function?

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: how to drop function?
Дата
Msg-id B91E4089-6472-48CD-B852-F904D3E5B31D@yahoo.com
обсуждение исходный текст
Ответ на Re: how to drop function?  ("J.V." <jvsrvcs@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "J.V."
Дата:
Сообщение: Re: how to drop function?
Следующее
От: "J.V."
Дата:
Сообщение: deferring pk constraint