3,765
回編集
差分
→clientテーブル
=== clientテーブル ===
% pg_dump --username=jq --table clients_old heroku_dump > clients_old.sql
==== 旧clientsテーブルをリストアする ====
<nowiki>% psql --username=jq tep5_development < ../old_other.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
ERROR: relation "clients_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 5067
setval
--------
5351
(1 row)
ERROR: relation "clients_pkey" already exists
CREATE INDEX
ERROR: relation "index_clients_on_user_id" already exists
CREATE INDEX
CREATE INDEX
ERROR: there is no unique constraint matching given keys for referenced table "users_old"
ALTER TABLE</nowiki>
旧テーブルのclientsをclientsとotherに分ける
