A new scenario for check constraints

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: A new scenario for check constraints
Date: 2021-10-08 11:13:51
Message-ID: CA+i5JwYNKCsw2YidFvuN1iSBd08KqaBUwWsYFgZfhz+yZsM-4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, All,

Can Postgres do some thing like this one?
Checking for potential constraint violations before entering SQL Server TRY
and CATCH logic (mssqltips.com)
<https://www.mssqltips.com/sqlservertip/2632/checking-for-potential-constraint-violations-before-entering-sql-server-try-and-catch-logic/>

The scenario is that we have a large Postgres table. Can a solution be
designed to create a table with constraint specifications and filter in all
records meeting specifications and producing reports (e.g., on problematic
ones)?

Regards,

David

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2021-10-08 17:09:25 Re: How to capture error message and save to a table in PostgreSQL?
Previous Message Shaozhong SHI 2021-10-08 09:45:45 How to capture error message and save to a table in PostgreSQL?