I just "drop user x cascade;" and recreate it.

OOOPS - just re-read the original post - sorry!