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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

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

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-2017 The PostgreSQL Global Development Group