差分

Tep3-onk

647 バイト追加, 2022年9月15日 (木) 07:07
database heroku_dump table dump
% pg_dump --username=jq --table clients_old heroku_dump > clients_old.sql
<nowiki>% psql --username=jq tep5_development < old_otherclients_old.sql
SET
SET
SET
SET
CREATE TABLEERROR: relation "clients_old" already exists
ALTER TABLE
ERROR: relation "clients_id_seq" already existsALTER TABLEALTER SEQUENCEALTER TABLECOPY 30665067 setval -------- 5351(1 row) ERROR: relation "clients_pkey" already existsERROR: relation "index_clients_on_jiin_id" already existsERROR: relation "index_clients_on_user_id" already existsERROR: relation "index_clients_on_user_id_and_jiin_id_and_name" already existsERROR: relation "index_clients_on_yomi_and_ie_id" already existsERROR: there is no unique constraint matching given keys for referenced table "users_old"ERROR: constraint "fk_rails_de6906508b" for relation "clients_old" already exists</nowiki>
=== ie_id 重複修正 ===