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

Disable PostgreSQL foreign key checks for migrations

637

публикации

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

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 62 #capsulecms 30 #featurerequest 26 #linux 22 #php 13 #windows 12 #phpstorm 11 #eclipse 8 #font 6 #nginx 5 #bug 5 #oldsite 4 #SEO 3 #iosevka 3 #antipattern 2 #quotes 2 #Цитаты 2 #mvc 2 #nano 2 #foobar 1 #apache 1 #git 1 #pidgin 1 #ssh 1 #curl 1 #datetimepicker 1 #https 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 #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 62 #capsulecms 30 #featurerequest 26 #linux 22 #php 13 #windows 12 #phpstorm 11 #eclipse 8 #font 6 #nginx 5 #bug 5 #oldsite 4 #SEO 3 #iosevka 3 #antipattern 2 #quotes 2 #Цитаты 2 #mvc 2 #nano 2 #foobar 1 #apache 1 #git 1 #pidgin 1 #ssh 1 #curl 1 #datetimepicker 1 #https 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 #puntoswitcher 1 #movie 1 #mariadb 1