Postgres Pro
Downloads
Home   >   mailing lists

Re: How to capture error message and save to a table in PostgreSQL? - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: How to capture error message and save to a table in PostgreSQL?
Date
Msg-id YWHd4oFbPd3eKpI0@hermes.hilbert.loc
Whole thread Raw
In response to How to capture error message and save to a table in PostgreSQL?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: How to capture error message and save to a table in PostgreSQL?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: A new scenario for check constraints
Next
From: Rob Sargent
Date:
Subject: Re: How to capture error message and save to a table in PostgreSQL?