Postgres Pro
Downloads
Home   >   mailing lists

Thread: Finding out types of error

Finding out types of error

From
Shaozhong SHI
Date:
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

From
"David G. Johnston"
Date:
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.