Re: ERROR: check constraint - PostgreSQL 9.2

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: check constraint - PostgreSQL 9.2
Date: 2016-01-25 04:17:36
Message-ID: 5F9D3FDD-5465-40CB-87A8-C19A2E06EA93@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jan 24, 2016, at 8:12 PM, "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)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 actually checking its validity.

--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2016-01-25 04:19:07 Re: ERROR: check constraint - PostgreSQL 9.2
Previous Message Joshua Berkus 2016-01-25 04:14:07 Re: A motion