| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
| Cc: | Postgresql Novice List <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: function delete problems |
| Date: | 2002-06-18 09:38:44 |
| Message-ID: | 9lvtguchfalqjqp5rsoqr03kbd4glrpb9o@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Taylor | 2002-06-18 14:03:53 | Which indexes to drop |
| Previous Message | Rory Campbell-Lange | 2002-06-18 09:14:26 | function delete problems |