Re: function delete problems
От
Manfred Koizar
Тема
Re: function delete problems
Дата
Msg-id
9lvtguchfalqjqp5rsoqr03kbd4glrpb9o@4ax.com
Ответ на
function delete problems (Rory Campbell-Lange)
Список
Дерево обсуждения
function delete problems Rory Campbell-Lange <rory@campbell-lange.net>
Re: function delete problems Josh Berkus <josh@agliodbs.com>
Re: function delete problems Manfred Koizar <mkoi-pg@aon.at>
On Tue, 18 Jun 2002 10:14:26 +0100, Rory Campbell-Lange wrote:
>I have made some functions which I wish to remove or remake. These are
>'returns opaque' functions that are used for triggers.
>
>I cannot remove them using the drop function command.
>
>obf=> drop function trgpeoplehidden;
>ERROR: parser: parse error at or near ";"
fred=# \h drop function
Command: DROP FUNCTION
Description: Removes a user-defined C function
Syntax:
DROP FUNCTION name ( [ type [, ...] ] )
^ ^
Don't omit these!
fred=# drop function bla;
ERROR: parser: parse error at or near ";"
fred=# drop function bla();
ERROR: RemoveFunction: function 'bla()' does not exist
.. which is correct.
Servus
Manfred
В списке pgsql-novice по дате отправления
