fail: alter table NOCHECK CONSTRAINT ALL;

Поиск
Список
Период
Сортировка
От J.V.
Тема fail: alter table NOCHECK CONSTRAINT ALL;
Дата
Msg-id 4E8B4EAF.6050307@gmail.com
обсуждение исходный текст
Ответы Re: fail: alter table NOCHECK CONSTRAINT ALL;  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: how to disable all pkey/fkey constraints globally
Следующее
От: "J.V."
Дата:
Сообщение: how to select one column into another in same table?