Re: Question about NOT NULL and default values.

On Thu, Oct 16, 2008 at 10:01 PM, Stephan Szabo
<sszabo@megazone.bigpanda.com> wrote:
> On Fri, 17 Oct 2008, Tim Uckun wrote:
>
>> Is there a way to change this behavior so that an attempt to set the
>> column to NULL will result in the default value being put in the
>> field?
>
> I don't think so specifically with default, but you could use a before
> trigger instead that would put in a value in the new row if NULL was
> given.

I'm pretty sure that will fail as the primary key or not null
constraint comes first.