3,728
回編集
差分
→2022-12 -14
ERROR: relation "public.jiins" does not exist</nowiki>
重複確認
<nowiki>=# SELECT ie_id, COUNT(ie_id)
FROM clients
where nusi = true GROUP BY ie_id
HAVING COUNT(ie_id) > 1
ORDER BY ie_id;
ie_id | count
-------+-------
2090 | 2
2129 | 2
2167 | 2
2174 | 2
.............</nowiki>
桁数を変えて重複を解消する
<nowiki>update_dump=# update clients SET ie_id = ie_id + 20000 where jiin_id = 2;
UPDATE 777