Re: how to check SQLSTATE

Поиск
Список
Период
Сортировка
От Hugo
Тема Re: how to check SQLSTATE
Дата
Msg-id f3d9ba990610061431o540790c1m9e03f7d92d04ea1b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to check SQLSTATE  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: how to check SQLSTATE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: exploiting features of pg to obtain polymorphism maintaining ref. integrity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to check SQLSTATE