On Tue, 18 Jun 2002 10:14:26 +0100, Rory Campbell-Lange <rory(at)campbell-lange(dot)net> 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 <name> 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
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.
In response to
pgsql-novice by date
|Next:||From: John Taylor||Date: 2002-06-18 14:03:53|
|Subject: Which indexes to drop|
|Previous:||From: Rory Campbell-Lange||Date: 2002-06-18 09:14:26|
|Subject: function delete problems|