Greetings,
On pgAdminIII 1.6, if you add a text column NOT NULL with a default ofa single space, it doesn't get quoted, and throws an error.
Kev