Среда, 18 марта 2020 в 09:18

Disable PostgreSQL foreign key checks for migrations

219

публикации

При залитии дампа, если есть внешние ключи, данные могут не залиться, поэтому...

For migration, it is easier to disable all triggers with:

SET session_replication_role = 'replica';

And after migration reenable all with

SET session_replication_role = 'origin';

Tags

#archive 61 #capsulecms 30 #featurerequest 26 #linux 22 #php 13 #windows 12 #eclipse 8 #phpstorm 8 #nginx 5 #bug 5 #oldsite 4 #font 4 #SEO 3 #antipattern 2 #quotes 2 #mvc 2 #nano 2 #foobar 1 #apache 1 #git 1 #pidgin 1 #curl 1 #datetimepicker 1 #rsync 1 #bootstrap 1 #cmd 1 #iconv 1 #cms 1 #skype 1 #pdf 1 #algorithm 1 #composer 1 #copypaste 1 #sourcetree 1 #singleton 1 #mysql 1 #meld 1 #pattern 1 #postgresql 1 #debian 1 #ideas 1 #strtok 1 #qt 1 #capsulecmsv1 1 #netbeans 1 #iosevka 1 #puntoswitcher 1 #movie 1 #mariadb 1

Featured

Special title treatment

With supporting text below as a natural lead-in to additional content.

Go somewhere

#archive 61 #capsulecms 30 #featurerequest 26 #linux 22 #php 13 #windows 12 #eclipse 8 #phpstorm 8 #nginx 5 #bug 5 #oldsite 4 #font 4 #SEO 3 #antipattern 2 #quotes 2 #mvc 2 #nano 2 #foobar 1 #apache 1 #git 1 #pidgin 1 #curl 1 #datetimepicker 1 #rsync 1 #bootstrap 1 #cmd 1 #iconv 1 #cms 1 #skype 1 #pdf 1 #algorithm 1 #composer 1 #copypaste 1 #sourcetree 1 #singleton 1 #mysql 1 #meld 1 #pattern 1 #postgresql 1 #debian 1 #ideas 1 #strtok 1 #qt 1 #capsulecmsv1 1 #netbeans 1 #iosevka 1 #puntoswitcher 1 #movie 1 #mariadb 1