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.
In response to
pgsql-novice by date
|Next:||From: Indira||Date: 2002-06-18 19:11:03|
|Subject: Re: unsubscribe NOVICE|
|Previous:||From: John Taylor||Date: 2002-06-18 16:47:55|
|Subject: Re: What gets inherited|