Re: Preferred method in creating primary key

> Deferred constraints can not be violated. The only thing that happens when a constraint
> is deferred is that the validity checking waits until the commit.

It may be a matter of semantics, but I would disagree. You can violate the constraint all you want if it is deferred. You just have to sort out the violations before you commit otherwise the constraint won't allow the operation.

Like I said, it may just be semantics and it may not be worth getting too picky about it.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"