Finding out types of error

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Finding out types of error
Date: 2023-07-08 18:55:35
Message-ID: CA+i5JwY8rkbXzLq62wh6mEj2-Q8cxoRjO7hDvEtaQqiogE05Aw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2023-07-08 18:58:52 Re: Finding out types of error
Previous Message Thomas Kellerer 2023-07-08 16:19:10 Re: How to remove duplicates in an array and maintain the order?