fail: alter table <table_name> NOCHECK CONSTRAINT ALL;

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: fail: alter table <table_name> NOCHECK CONSTRAINT ALL;
Date: 2011-10-04 18:21:35
Message-ID: 4E8B4EAF.6050307@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have tried:

alter table <table_name> NOCHECK CONSTRAINT ALL;

and it highlights (squiggles) NOCHECK saying : ERROR: syntax error at or
near "NOCHECK" SQL state: 42601 character 20

but everything I lookup says this this is the way to disable all
constraints on a table.

Also is there a way to disable all existing constraints on all tables
everywhere (specifically all pkey & fkey constraints irrespective of how
they were created) in one statement?

I have searched and searched and find nothing that works.

J.V.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.V. 2011-10-04 18:24:34 how to select one column into another in same table?
Previous Message John R Pierce 2011-10-04 18:15:21 Re: how to disable all pkey/fkey constraints globally