Re: Return Opaque / Error in Function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Return Opaque / Error in Function
Date
Msg-id 15982.1007014508@sss.pgh.pa.us
Whole thread Raw
In response to Return Opaque / Error in Function  (Knud Müller <k.mueller@portrix.net>)
List pgsql-sql
Knud Müller <k.mueller@portrix.net> writes:
> mag=# Delete from productvariant where productvariantid='4015223929157';
> ERROR:  control reaches end of trigger procedure without RETURN
> DEBUG:  Last error occured while executing PL/pgSQL function
> update_productvariant
> DEBUG:  at END of toplevel PL block
> ERROR:  control reaches end of trigger procedure without RETURN

Your function looks fine to me, and executes fine here.  Not sure what
the problem is.  You are using a recent version of Postgres, no?
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: distinct() vs distinct on ()
Next
From: Tom Lane
Date:
Subject: Re: PL/pgSQL loops?