1BEGIN; 2 3ALTER TABLE admin DROP CONSTRAINT IF EXISTS admin_pkey; 4 5ALTER TABLE admin ADD PRIMARY KEY (job); 6 7COMMIT; 8