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
