I don't really want to go back to numerical primary keys if I can help it, but it doesn't look like there is a sensible workaround for this other than externally generate the id