agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@lists.postgresql.org
Subject: Re: How to capture error message and save to a table in PostgreSQL?
Date: Sat, 9 Oct 2021 20:22:26 +0200
Message-ID: <YWHd4oFbPd3eKpI0@hermes.hilbert.loc> (raw)
In-Reply-To: <CA+i5Jwa84QGO87znD8WBMqYMGB=t-6ZrDxUJ+UHbtF2fDyZQng@mail.gmail.com>
References: <CA+i5Jwa84QGO87znD8WBMqYMGB=t-6ZrDxUJ+UHbtF2fDyZQng@mail.gmail.com>

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

view thread (4+ messages)  latest in thread

Message-ID: <YWHd4oFbPd3eKpI0@hermes.hilbert.loc>
Permalink:  ../YWHd4oFbPd3eKpI0@hermes.hilbert.loc/
Also on:    postgresql.org/message-id/YWHd4oFbPd3eKpI0@hermes.hilbert.loc

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Karsten.Hilbert@gmx.net, pgsql-sql@lists.postgresql.org
  Subject: Re: How to capture error message and save to a table in PostgreSQL?
  In-Reply-To: <YWHd4oFbPd3eKpI0@hermes.hilbert.loc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox