Thanks. I understand that much. I want to know if this is the intended behaviour. --elein On Wed, Jun 29, 2005 at 08:25:09PM +0000, Matt Miller wrote: > 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. > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)