Exception handling

Поиск
Список
Период
Сортировка
Искать
От
sam
Тема
Exception handling
Дата
Msg-id
8e80cf20-c8eb-4e8f-b796-cf142429167b@34g2000hsf.googlegroups.com
Список
Дерево обсуждения
Exception handling sam <sam.mahindrakar@gmail.com>
Re: Exception handling Stephan Szabo <sszabo@megazone.bigpanda.com>
Can someone explain me about the exception handling in postgresql. Iam
not understanding the scope of a exception block. The exact confusion
that iam facing is as follows:
I have a procedure as follows
BEGIN
EXECUTE an update statement

EXECUTE an insert statement
EXCEPTION WHEN integrity_conatraint_violation THEN
RAISE NOTICE
END;

This procedure is called within another procedure. Now when an
exception is caught the updates are also getting rolled back. I need
the exception block to work only for the insert statement. But if i
dont write the exception block the whole program stops.
Any suggestions?

Thanks
Sam
В списке pgsql-general по дате отправления
От: debh
Дата:
Сообщение: tablespaces not working
От: Stephan Szabo
Дата:
Сообщение: Re: Exception handling
FAQ