差分

=# delete from schedules where client_id in (132, 212, 537, 550, 2697, 2843, 2844, 2845, 2846, 2848, 2849, 2850, 2861, 3049, 3050, 3076, 20081, 22584, 22585, 22599, 22653, 22657, 22697, 22887, 22892, 23073, 23976, 33056, 33057, 33058, 33059, 33062, 33063, 33064, 33065, 33066, 33068, 33069, 33070, 33077, 33078, 33079, 33081); 改めてリストア　コピーする <nowiki>jq@MacBook-Pro tep5 % pg_dump --username=jq --table schedules update_heroku > ../new_schedules.sqljq@MacBook-Pro tep5 % psql --username=jq tep5_development < ../new_schedules.sql SETSETSETSETSET set_config ------------ (1 row) SETSETSETSETSETSETERROR: relation "schedules" already existsALTER TABLEERROR: relation "schedules_id_seq" already existsALTER TABLEALTER SEQUENCEALTER TABLECOPY 3701 setval -------- 4603(1 row) ERROR: multiple primary keys for table "schedules" are not allowedERROR: relation "index_schedules_on_client_id" already existsERROR: relation "index_schedules_on_content" already existsERROR: relation "index_schedules_on_datetime" already existsERROR: relation "index_schedules_on_ie_id" already existsERROR: relation "index_schedules_on_jiin_id" already existsERROR: relation "index_schedules_on_user_id" already exists</nowiki>