global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;
count | encoded_number
-------+----------------
2 | 166772
2 | 166118
2 | 166123
(3 rows)
global=> BEGIN;
BEGIN
global=> delete from personinfo.access_cards where access_card_id IN ('130275','130186','130891');
DELETE 3
global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;
count | encoded_number
-------+----------------
(0 rows)
global=> COMMIT;
COMMIT
global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;
count | encoded_number
-------+----------------
(0 rows)