Re: Exhaused sequence
- From: Steven Patenaude <spatenau@xxxxxxxxx>
- To: jknight@xxxxxxxxxxxxxx, "Oracle-L (E-mail)" <Oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Feb 2005 15:59:45 -0600
On Fri, 18 Feb 2005 11:02:25 -0600, Knight, Jon <jknight@xxxxxxxxxxxxxx> wrote:
> Thanks to everyone for the suggestions. And, Jared ... I guess I should
> give him a break, but I can only pay $1.99 per week.
>
> We discovered that the application code already checks for an existing
> record with the same sequence before inserts, so we've just recreated the
> sequence with a sufficiently low starting value to fill in the gaps.
>
> Thanks,
> Jon
Oh, that's no fun! I wanted to see how the suggestions ended up
working in production.
Negative numbers really tickled my funnybone. "What do you mean I'm
customer negative 50832?!?"
Steven
ps I hate forgetting to "reply all".
--
//www.freelists.org/webpage/oracle-l
Other related posts:
