reset_id_pkey

/ # psql -d skydive -U skydive
psql (17.2)
Type "help" for help.

skydive=> \dt
                 List of relations
 Schema  |          Name          | Type  |  Owner  
---------+------------------------+-------+---------
 skydive | Events                 | table | skydive
 skydive | FTBLP_tunnel_timesheet | table | skydive
 skydive | VFS_draw_FAI_indoor    | table | skydive
 skydive | epheo_logbook          | table | skydive
(4 rows)

skydive=> ALTER TABLE epheo_logbook ADD COLUMN new_id SERIAL;
ALTER TABLE
skydive=> ALTER TABLE epheo_logbook ADD COLUMN new_id SERIAL;
ALTER TABLE

skydive=> SELECT conname
skydive-> FROM pg_constraint
skydive-> WHERE conrelid = 'epheo_logbook'::regclass AND contype = 'p';
   conname    
--------------
 logbook_pkey
(1 row)

skydive=> ALTER TABLE epheo_logbook DROP CONSTRAINT logbook_pkey;
ALTER TABLE
skydive=> ALTER TABLE epheo_logbook DROP COLUMN id;
ALTER TABLE
skydive=> ALTER TABLE epheo_logbook RENAME COLUMN new_id TO id;
ALTER TABLE
skydive=> ALTER TABLE epheo_logbook ADD PRIMARY KEY (id);
ALTER TABLE