Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Karsten Hilbert
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Karsten Sure, they are just a search engine's use away. > Are there any examples on the web these days? > That sounds brilliant. :Am Sun, Oct 03, 2021 at 07:44:41PM +0100 schrieb Shaozhong SHI

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Shaozhong SHI
Hi, Christian, Brilliant! Some years ago, I did something similar and saved problematic ones for data collector. Now, I am reviewing to see whether there be any elegant way to automate reporting and giving feedback. Regards, David On Sunday, 3 October 2021, Christian Ramseyer wrote: > > The

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Christian Ramseyer
> The reported error looks like this: > > postgres@dellstore ERROR: new row for relation "test_customers" > violates check constraint "check_age" .. > > This errors appears in the serverlog which has many format and > forwarding options, you can read about them here: On 03.10.

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Shaozhong SHI
Hi, Kirsten, That sounds brilliant. Are there any examples on the web these days? Regards, David On Sunday, 3 October 2021, Karsten Hilbert wrote: > Am Sun, Oct 03, 2021 at 07:16:32PM +0100 schrieb Shaozhong SHI: > > > That is interesting. Can errors be captured and saved as data with > > scrip

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Karsten Hilbert
Am Sun, Oct 03, 2021 at 07:16:32PM +0100 schrieb Shaozhong SHI: > That is interesting. Can errors be captured and saved as data with > scripting? Depends on what the script does. If the script runs (or is written in) Python the canonical PG driver (psycopg2/3) will give you such data. Karsten

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Shaozhong SHI
cking, validation and > > reporting within PostgreSQL? > > > > How best to use PostgreSQL CHECK Constraint for data quality checking, > > validation and reporting? > > > > Can we report on errors in a detailed and specific way? For instance, > > can we produce report

Re: PostgreSQL CHECK Constraint

2021-10-03 Thread Christian Ramseyer
On 03.10.21 09:31, Shaozhong SHI wrote: > > Has anyone got experience with data quality checking, validation and > reporting within PostgreSQL? > > How best to use PostgreSQL CHECK Constraint for data quality checking, > validation and reporting?   > > Can we report

PostgreSQL CHECK Constraint

2021-10-03 Thread Shaozhong SHI
Has anyone got experience with data quality checking, validation and reporting within PostgreSQL? How best to use PostgreSQL CHECK Constraint for data quality checking, validation and reporting? Can we report on errors in a detailed and specific way? For instance, can we produce report on