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

Re: function delete problems

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>,Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: function delete problems
Date: 2002-06-18 17:54:59
Message-ID: 200206181054.59774.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
Rory,

Warning: You're about to feel really dumb.  Don't worry, it's happened to me, 
too.

> I cannot remove them using the drop function <name> command.
> 
> obf=> drop function trgpeoplehidden;
> ERROR:  parser: parse error at or near ";"

That's
DROP FUNCTION trgpeoplehidden();
the parens are mandatory.

You also need to drop the trigger, manually ... dropping the function does not 
automatically drop the trigger, though it does break the trigger.

-- 
-Josh Berkus


In response to

pgsql-novice by date

Next:From: IndiraDate: 2002-06-18 19:11:03
Subject: Re: unsubscribe NOVICE
Previous:From: John TaylorDate: 2002-06-18 16:47:55
Subject: Re: What gets inherited

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