Jean-Luc Lachance <jllachan(at)nsd(dot)ca> writes:
> The last part of my message should have read:
> I am running 7.2.3
Ah. In that case, you are right: COPY fills missing fields with nulls,
not default values. This is fixed in 7.3.
regards, tom lane