Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject How to capture error message and save to a table in PostgreSQL?
Date
Msg-id CA+i5Jwa84QGO87znD8WBMqYMGB=t-6ZrDxUJ+UHbtF2fDyZQng@mail.gmail.com
Whole thread Raw
Responses Re: How to capture error message and save to a table in PostgreSQL?
Re: How to capture error message and save to a table in PostgreSQL?
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Metin Ulusinan
Date:
Subject: Re: Create trigger on after logon on schema
Next
From: Shaozhong SHI
Date:
Subject: A new scenario for check constraints