* Stephen Frost (sfr...@snowman.net) wrote: > * Stephen Frost (sfr...@snowman.net) wrote: > > > Is there similar problems with unique or exclusion constraints? > > > > That's certainly an excellent question.. I'll have to go look. > > Looks like there is an issue here with CHECK constraints and NOT NULL > constraints, yes. The uniqueness check complains about the key already > existing and returns the key, but I don't think that's actually a > problem- to get that to happen you have to specify the new key and > that's what is returned.
Yeah, I take that back. If there is a composite key involved then you
can run into the same issue- you update one of the columns to a
conflicting value and get back the entire key, including columns you
shouldn't be allowed to see.
Ugh.
Thanks,
Stephen
signature.asc
Description: Digital signature
