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: (view raw, whole thread or download thread mbox)
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:

You cannot disable a check constraint.

Perhaps a staging table is advisable here?

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-2017 The PostgreSQL Global Development Group