Обсуждение: Finding out types of error

Поиск
Список
Период
Сортировка

Finding out types of error

От
Shaozhong SHI
Дата:
Having the following:

Begin

   insert into a_table select * from a_function

Exception
   Raise note 'Skipped"



This works.

Can it trap types of errors to find out what is wrong

Regards,

David

Re: Finding out types of error

От
"David G. Johnston"
Дата:
On Sat, Jul 8, 2023 at 11:55 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:

Can it trap types of errors to find out what is wrong


That is what "condition" is for.
https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

David J.