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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general