Re: [BUGS] BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery

2010-05-30 Thread Matthew Nourse
Kevin Grittner wrote: Tom Lane wrote: < NOT NULL constraints at the domain level suck. Don't use 'em. +1 As someone who uses domains very heavily, I can attest that the semantics of that are very weak. Whether a domain is nullable depends almost entirely on the context of its use, which

Re: [BUGS] BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery

2010-05-30 Thread Matthew Nourse
Tom Lane wrote: Matthew Nourse writes: As NOT NULL on domains doesn't always prevent a value from becoming NULL (and because it "sucks" :) ) would you consider deprecating the not-null-on-domains feature and then removing it from some future version of PostgreSQL? We can&#