NULL becomes default

From: "Julian Scarfe" <julian(at)avbrief(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: NULL becomes default
Date: 2006-08-17 18:11:21
Message-ID: 029c01c6c228$8e8e5210$0600a8c0@Wilbur
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

A surrogate key has been introduced on a table with modifiers:

Column | Type |
Modifiers
-------------+-----------------------------+------------------------------------------------------------
new_id | integer | not null default
nextval(('some_id_seq'::text)::regclass)

However, some legacy software inserts into the table by first getting column
names and then composing an INSERT for all the columns, filling in any
undefined values with NULLs.

Thus when it attempts to insert a row I get a:

ERROR: null value in column "new_id" violates not-null constraint

Thus I would like NULLs in such INSERTs to be treated as DEFAULT rather than
violating the constraint. Is there an easy way to do that at the database
level?

Thanks

Julian

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sumeet 2006-08-17 18:22:03 Re: NULL becomes default
Previous Message MaXX 2006-08-17 12:54:07 Re: Help with optional parameters