Re: fail: alter table <table_name> NOCHECK CONSTRAINT ALL;

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: fail: alter table <table_name> NOCHECK CONSTRAINT ALL;
Date: 2011-10-04 19:20:20
Message-ID: 4E8B5C74.8010708@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.V. 2011-10-04 19:21:37 Re: how to select one column into another in same table?
Previous Message Guillaume Lelarge 2011-10-04 19:12:15 Re: fail: alter table <table_name> NOCHECK CONSTRAINT ALL;