差分

移動先: 案内検索

Tep3-onk-2

965 バイト追加, 2022年9月27日 (火) 13:40
schedulesテーブル
差分を削除する
=# 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>
=== ダンプ ここまで形を整えたデータベースをバックアップしとく ===

案内メニュー