Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAT6FHm20698 for ; Thu, 29 Nov 2001 01:15:17 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAT6F8k15985; Thu, 29 Nov 2001 01:15:08 -0500 (EST) To: =?iso-8859-1?Q?Knud_M=FCller?= cc: pgsql-sql@postgresql.org Subject: Re: Return Opaque / Error in Function In-reply-to: References: Comments: In-reply-to =?iso-8859-1?Q?Knud_M=FCller?= message dated "Wed, 28 Nov 2001 16:28:24 +0100" Date: Thu, 29 Nov 2001 01:15:08 -0500 Message-ID: <15982.1007014508@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/399 X-Sequence-Number: 5781 =?iso-8859-1?Q?Knud_M=FCller?= 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