Re: Automatic random number on row creation

On Thu, 29 Dec 2005 13:05:41 -0500, Mark C. Stock wrote:

> looks like concatenating a sequence or just trapping UK violation would
> finish the story

Concatenating a sequence would be far better because handling would require a trap handler that would roll the transaction back, generate new key and re-execute the insert. That would give you unpredictable transaction times and would complicate the matter enormously.

-- 
http://www.mgogala.com