Re: Finding out types of error

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Finding out types of error
Date: 2023-07-08 18:58:52
Message-ID: CAKFQuwaaguuSt_ocFa=aCX1041h_ZNyQOCsJAukHD_pZS-_3bw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Jul 8, 2023 at 11:55 AM Shaozhong SHI <shishaozhong(at)gmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2023-07-13 14:46:12 Can we set time exception?
Previous Message Shaozhong SHI 2023-07-08 18:55:35 Finding out types of error