差分

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 重複修正 ===

• ← 古い編集
• 新しい編集 →

Shudo

ビューロクラット、管理者

3,765

回編集