On Wed, 2005-06-29 at 13:04 -0700, elein wrote:
> default constraint
> ...
> elein=# insert into nulldefault values (NULL);
> ERROR: null value in column "one" violates not-null constraint
I think the idea of a DEFAULT value is to tell the DB what to supply
only if you omit the column from the insert statement altogether. If
you deliberately call for a NULL, the DB will try to oblige.