Home > mailing lists

Re: Disabling constraint check - Mailing list pgsql-sql

From	Richard Broersma
Subject	Re: Disabling constraint check
Date	September 17, 2012 23:42:35
Msg-id	CABvLTWEXfEZXSWRbiKaW=EzpYaWMmBv3hch4CAHqTMn4LKvz0w@mail.gmail.com Whole thread Raw
In response to	Disabling constraint check (Salomao Domingos <salomaodomingos@gmail.com>)
List	pgsql-sql

On Mon, Sep 17, 2012 at 11:58 AM, Salomao Domingos <salomaodomingos@gmail.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.

From: "Oliveiros d'Azevedo Cristina"
Date: 17 September 2012, 22:33:50
Subject: Re: Disabling constraint check

From: "BACHELART PIERRE (CIS/SCC)"
Date: 22 September 2012, 10:59:36
Subject: matching a timestamp field