Re: Exhaused sequence

From: Steven Patenaude <spatenau_at_gmail.com>
Date: Fri, 18 Feb 2005 15:59:45 -0600
Message-ID: <10644b9e0502181359582cad07@mail.gmail.com>

On Fri, 18 Feb 2005 11:02:25 -0600, Knight, Jon <jknight_at_concordefs.com> 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".

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 18 2005 - 17:09:49 CST