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?
From: "Markus Schaber" <[EMAIL PROTECTED]>
Did you try a "before insert" trigger that checks new_id for null
values, and replaces it with nextval()?
So thinking about this a little more, it requires me to be able to change a
column value to DEFAULT (unless I implement the default from scratch in the
trigger, but that feels messy). I don't have much experience of triggers:
can I do that?
Thanks
Julian
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
