Re: fail: alter table NOCHECK CONSTRAINT ALL;

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
>
>