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

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: How to capture error message and save to a table in PostgreSQL?
Date: 2021-10-08 09:45:45
Message-ID: CA+i5Jwa84QGO87znD8WBMqYMGB=t-6ZrDxUJ+UHbtF2fDyZQng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, All,

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?

INSERT INTO test3 ("Record Type", "Unique Reference Number", "Supplier
Reference Number", "Post Code")
SELECT "Record Type", "Unique Reference Number", "Supplier Reference
Number", "Post Code" from test;

ERROR: new row for relation "test3" violates check constraint "test3_Post
Code_check"
DETAIL: Failing row contains (L, 14986526, 1207174, null, null, null,
null, null, null, SURREY, null, null, null, null, null, null, null, null).
SQL state: 23514

Regards,
David

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2021-10-08 11:13:51 A new scenario for check constraints
Previous Message Metin Ulusinan 2021-10-07 20:53:39 Re: Create trigger on after logon on schema