MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 8 Jul 2023 19:55:35 +0100
Message-ID: 
 <CA+i5JwY8rkbXzLq62wh6mEj2-Q8cxoRjO7hDvEtaQqiogE05Aw@mail.gmail.com>
Subject: Finding out types of error
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000cb2bd05fffe4c07"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwY8rkbXzLq62wh6mEj2-Q8cxoRjO7hDvEtaQqiogE05Aw%40mail.gmail.com>
Precedence: bulk

--0000000000000cb2bd05fffe4c07
Content-Type: text/plain; charset="UTF-8"

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

--0000000000000cb2bd05fffe4c07
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Having the following:<div><br></div><div>Begin</div><div><=
br></div><div>=C2=A0 =C2=A0insert into a_table select * from a_function</di=
v><div><br></div><div>Exception</div><div>=C2=A0 =C2=A0Raise note &#39;Skip=
ped&quot;</div><div><br></div><div><br></div><div><br></div><div>This works=
.</div><div><br></div><div>Can it trap types of errors to find out what is =
wrong</div><div><br></div><div>Regards,</div><div><br></div><div>David</div=
></div>

--0000000000000cb2bd05fffe4c07--