"PEDRO LOPEZ" <p.lopez@bresnan.net> writes:
> after struggling with 'function not defined errors', and unable to see what
> was wrong I redefined the function as:
> CREATE OR REPLACE FUNCTION currentstatus_dtrig() RETURNS opaque AS
> ...
> and got the message to the effect of 'redefining return type as trigger',
Yup.
> This is strange, AFAICT I followed the documentation setting up the trigger
> and functions (correct parameter signature and return type).
It's been a long time (at least since 7.3) since the documentation
recommended using OPAQUE for anything.
regards, tom lane