Re: how to check SQLSTATE - Mailing list pgsql-general

From Hugo
Subject Re: how to check SQLSTATE
Date
Msg-id f3d9ba990610061431o540790c1m9e03f7d92d04ea1b@mail.gmail.com
Whole thread Raw
In response to Re: how to check SQLSTATE  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: how to check SQLSTATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

the symbol is correct , i checked it in the appendix A postgres error codes and constants, have you got any idea what the problem could be.
....
loop
      Begin
           fetch bla.....
           Exception
                     when no_data then                              
                              exit;
     end;
      ....
end loop; 
......
this is on suse 10, postgres 8.1.4

thanks in advance

Hugo


pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: exploiting features of pg to obtain polymorphism maintaining ref. integrity
Next
From: Tom Lane
Date:
Subject: Re: how to check SQLSTATE