Andrew Dunstan <[EMAIL PROTECTED]> writes: > What seems worse is that it still fails even if you declare the domain > to have a default value.
Hmm, that seems like it could be a bug. We don't currently consider that a rowtype includes the parent table's defaults or constraints. But if we are going to honor a domain's constraints then maybe the domain's default has to float along with that. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster