Re: Return Opaque / Error in Function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Knud Müller <k(dot)mueller(at)portrix(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Return Opaque / Error in Function
Date: 2001-11-29 06:15:08
Message-ID: 15982.1007014508@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?iso-8859-1?Q?Knud_M=FCller?= <k(dot)mueller(at)portrix(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2001-11-29 08:45:38 date_part vs extract
Previous Message Tom Lane 2001-11-29 06:08:36 Re: PL/pgSQL loops?