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 ";"
Quoting the function name doesn't seem to help.
What is the best ways of listing, deleting and updating functions?
(Also, is there a way of seeing what function a trigger on a table
calls? I've tried \d <triggername>).
Thanks for any help
Rory
--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>