Re: Control reached end of trigger procedure without RETURN

From: MoNiLlO <monillo(at)adinf(dot)es>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Control reached end of trigger procedure without RETURN
Date: 2011-01-25 15:22:37
Message-ID: 4D3EEABD.3080703@adinf.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

El 25/01/2011 16:06, Tom Lane escribió:
> 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
>
Thanks for open my eyes.

Great stupidity to mine. This is a second trigger that has no code and
therefore there is no return.

I feel the lost of time.

Best regards.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adelo 2011-01-25 15:24:46 Re: Control reached end of trigger procedure without RETURN
Previous Message MoNiLlO 2011-01-25 15:21:03 Re: Control reached end of trigger procedure without RETURN