Re: fail: alter table NOCHECK CONSTRAINT ALL; - Mailing list pgsql-general

From J.V.
Subject Re: fail: alter table NOCHECK CONSTRAINT ALL;
Date
Msg-id 4E8B5C74.8010708@gmail.com
Whole thread Raw
In response to Re: fail: alter table NOCHECK CONSTRAINT ALL;  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: fail: alter table NOCHECK CONSTRAINT ALL;  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
Is there a way to disable all "trigger user' in one statement? (and then
re-enable?)

One docs says primary keys and foreign keys are "user triggers"

thanks


J.V.


On 10/4/2011 1:12 PM, Guillaume Lelarge wrote:
>
> Not sure where you look up, but there's no way to disable constraints in
> PostgreSQL. You can disable triggers and rules, but not the constraints.
>
> See http://www.postgresql.org/docs/9.1/interactive/sql-altertable.html
>
>

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: fail: alter table NOCHECK CONSTRAINT ALL;
Next
From: "J.V."
Date:
Subject: Re: how to select one column into another in same table?