Skip site navigation (1) Skip section navigation (2)

Re: Disabling constraint check

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Salomao Domingos <salomaodomingos(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Disabling constraint check
Date: 2012-09-17 20:42:31
Message-ID: CABvLTWEXfEZXSWRbiKaW=EzpYaWMmBv3hch4CAHqTMn4LKvz0w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Mon, Sep 17, 2012 at 11:58 AM, Salomao Domingos <
salomaodomingos(at)gmail(dot)com> wrote:

> ... however how can I disabling CHECK CONSTRAINT too?
>

From the sub-section on DEFERRABLE NOT DEFERRABLE:
http://www.postgresql.org/docs/9.2/interactive/sql-createtable.html#SQL-CREATETABLE-EXCLUDE

You cannot disable a check constraint.

Perhaps a staging table is advisable here?

-- 
Regards,
Richard Broersma Jr.

In response to

pgsql-sql by date

Next:From: BACHELART PIERRE (CIS/SCC)Date: 2012-09-20 11:01:15
Subject: matching a timestamp field
Previous:From: Oliveiros d'Azevedo CristinaDate: 2012-09-17 19:33:43
Subject: Re: Disabling constraint check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group