Request a Demo
Home   >   mailing lists

Re: ERROR: check constraint - PostgreSQL 9.2 - Mailing list pgsql-general

From Christophe Pettus
Subject Re: ERROR: check constraint - PostgreSQL 9.2
Date
Msg-id E8B0CE85-ABD8-42EC-B8D3-5937CBC5D81A@thebuild.com
Whole thread Raw
In response to Re: ERROR: check constraint - PostgreSQL 9.2  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Responses Re: ERROR: check constraint - PostgreSQL 9.2
List pgsql-general
Tree view 
On Jan 24, 2016, at 9:01 PM, Charles Clavadetscher <clavadetscher@swisspug.org> wrote:

> What is the point of having a check constraint that is not checked?

Well, it *is* checked going into the future; it's just not checked at the time the constraint is added.  Ultimately,
youdo want to fix the data, but this makes it a two-step process, and reduces the time the table is locked against
access.

pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: Re: ERROR: check constraint - PostgreSQL 9.2
Next
From: Thomas Kellerer
Date:
Subject: Re: 9.5 new features