Re: Checking FKs after COPY and disabled Triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Checking FKs after COPY and disabled Triggers
Дата
Msg-id 28631.1080829441@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Checking FKs after COPY and disabled Triggers  (Janning Vygen <vygen@gmx.de>)
Ответы Re: Checking FKs after COPY and disabled Triggers
Список pgsql-general
Janning Vygen <vygen@gmx.de> writes:
> can i check my database for violating FKs if i populated the database with FK
> constraints disabled?

Drop the constraints and then add them back afterwards.  You might want
to think about dropping and rebuilding indexes as well.

            regards, tom lane

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