let confirmation_id assignment be done by postgresql trigger