差分

Tep3-onk-2

1,048 バイト追加, 2022年10月3日 (月) 10:21
戒名テーブル 変更あり
<nowiki>update_heroku=# delete from kaimyous where client_id in (21, 27, 35, 38, 39, 44, 46, 56, 57, 63, 71, 73, 78, 89, 101, 106, 111, 126, 127, 135, 144, 147, 156, 173, 174, 176, 186, 188, 189, 230, 310, 373, 404, 473, 701, 804, 872, 936, 953, 972, 998, 1590, 1671, 1777, 2249, 2290, 22653, 34681);
DELETE 81</nowiki>
 
ダンプ リストア
<nowiki>jq@MacBook-Pro tep5 % pg_dump --username=jq --table kaimyous update_heroku > ../new_kaimyous.sql
jq@MacBook-Pro tep5 % psql --username=jq tep5_development < ../new_kaimyous.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
 
SET
SET
SET
SET
SET
SET
ERROR: relation "kaimyous" already exists
ALTER TABLE
ERROR: relation "kaimyous_id_seq" already exists
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 3294
setval
--------
4230
(1 row)
 
ERROR: multiple primary keys for table "kaimyous" are not allowed
ERROR: relation "index_kaimyous_on_client_id" already exists
ERROR: relation "index_kaimyous_on_client_id_and_content" already exists
ERROR: relation "index_kaimyous_on_date" already exists
ERROR: relation "index_kaimyous_on_ie_id" already exists
ERROR: relation "index_kaimyous_on_jiin_id" already exists
ERROR: relation "index_kaimyous_on_user_id" already exists
ERROR: relation "index_kaimyous_on_user_id_and_jiin_id" already exists
ERROR: relation "public.jiins" does not exist</nowiki>
== UUIDを有効にする ==