Skip site navigation (1) Skip section navigation (2)

Re: function delete problems

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: John TaylorDate: 2002-06-18 14:03:53
Subject: Which indexes to drop
Previous:From: Rory Campbell-LangeDate: 2002-06-18 09:14:26
Subject: function delete problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group