Re: How to capture error message and save to a table in PostgreSQL?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: How to capture error message and save to a table in PostgreSQL?
Date: 2021-10-09 18:22:26
Message-ID: YWHd4oFbPd3eKpI0@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Am Fri, Oct 08, 2021 at 10:45:45AM +0100 schrieb Shaozhong SHI:

> I wish to test out to produce a table when data violates constraints when
> insert into a new table with constraint set. How to capture and save error
> message to a new table?

That depends on how you access the table and at which level
you wish the above to happen.

You need to be less generic to get better help.

Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2021-10-09 18:29:27 Re: How to capture error message and save to a table in PostgreSQL?
Previous Message Steve Midgley 2021-10-08 19:01:59 Re: A new scenario for check constraints