On Thu, 16 Oct 2008, Scott Marlowe wrote: > On Thu, Oct 16, 2008 at 10:01 PM, Stephan Szabo > <sszabo@xxxxxxxxxxxxxxxxxxxxx> 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. Well, since he said that he'd removed the not null constraint in his testing, I figured that was a viable option. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
