Postgres Pro
Downloads
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 5F9D3FDD-5465-40CB-87A8-C19A2E06EA93@thebuild.com
Whole thread Raw
In response to ERROR: check constraint - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: ERROR: check constraint - PostgreSQL 9.2  (Christophe Pettus <xof@thebuild.com>)
Re: ERROR: check constraint - PostgreSQL 9.2  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
List pgsql-general
Tree view 
On Jan 24, 2016, at 8:12 PM, "drum.lucas@gmail.com" <drum.lucas@gmail.com> wrote:

> How can I solve the problem? How can I get the command successfully be done?

Two options:

1. Fix the data.

2. Use the NOT VALID option on ALTER TABLE ... ADD constraint, which allows the addition of a constraint without
actuallychecking its validity. 

--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: Joshua Berkus
Date:
Subject: Re: A motion
Next
From: Christophe Pettus
Date:
Subject: Re: ERROR: check constraint - PostgreSQL 9.2