ERROR: check constraint - PostgreSQL 9.2

Поиск

Список

Период

Сортировка

От	drum.lucas@gmail.com
Тема	ERROR: check constraint - PostgreSQL 9.2
Дата	25 января 2016 г. 07:13:08
Msg-id	CAE_gQfXTns1FR5Fx9wxpo1oZYwat639ua-gAqWZyNg201HCU=Q@mail.gmail.com обсуждение исходный текст
Ответы	Re: ERROR: check constraint - PostgreSQL 9.2 (Christophe Pettus <xof@thebuild.com>) Re: ERROR: check constraint - PostgreSQL 9.2 (Vick Khera <vivek@khera.org>)
Список	pgsql-general

Дерево обсуждения

Hi all, need some help to add a constraint to an existing table (with data).

I'm running the command:

Query:

ALTER TABLE integrations.accounts DROP CONSTRAINT IF EXISTS cc_at_least_one_setting_needed,   ADD CONSTRAINT cc_at_least_one_setting_needed CHECK (("qb_settings" IS NOT NULL) or                                                         ("xero_settings" IS NOT NULL) or                                                         ("freshbooks_settings" IS NOT NULL) or                                                         ("myob_settings" IS NOT NULL) or                                                         ("ppy_settings" IS NOT NULL));

But, I got the following error:

ERROR: check constraint "cc_at_least_one_setting_needed" is violated by some row

So, I made a SELECT to get some data, to see where's the issue:

SELECT * FROM integrations.accounts WHERE qb_settings IS NULL OR xero_settings IS NULL OR freshbooks_settings IS NULL OR myob_settings IS NULL OR ppy_settings IS NULL;