Andrew Dunstan <andrew@dunslane.net> 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