View Single Post

   
  #5 (permalink)  
Old 04-09-2008, 11:43 AM
Tom Lane
 
Posts: n/a
Default Re: how to check SQLSTATE

Hugo <htakada@gmail.com> writes:
> Hi again, thanks for your guidance, this is the error I got trying to save
> my fuction:
> ERROR: unrecognized exception condition "no_data"
> CONTEXT: compile of PL/pgSQL function "fn_verificar_aportes_socio" near
> line 36


NO_DATA isn't an error condition, only a warning, thus there is no case
in which an exception block would trap it. So plpgsql doesn't bother to
recognize it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote