update assign pg spec