Re: Control reached end of trigger procedure without RETURN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: MoNiLlO <monillo(at)adinf(dot)es>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Control reached end of trigger procedure without RETURN
Date: 2011-01-25 15:06:46
Message-ID: 20377.1295968006@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

MoNiLlO <monillo(at)adinf(dot)es> writes:
> When I launch one insert returns error:
> I put the function and the returned error.

> CREATE OR REPLACE FUNCTION ventas_det_a_ventas_imp()
> RETURNS trigger AS
> ...

> ERROR: control reached end of trigger procedure without RETURN
> CONTEXT: PL/pgSQL function "ventas_imp_a_ventas_cab"

The function that's lacking a RETURN is not the one you're showing us.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message MoNiLlO 2011-01-25 15:21:03 Re: Control reached end of trigger procedure without RETURN
Previous Message Santosh Bhujbal (sabhujba) 2011-01-25 12:39:49 Queyring for columns which are exist in table.