Re: Duplicate Key -- Have I missed something

On Sat, Aug 06, 2005 at 10:00:10PM -0400, Robert Perry wrote:
> I have a production environment that is running the code that
> caused this problem about once every 30 seconds or so, with two
> clients. It normally runs very well, but I was suddenly hit with a
> duplicate key violation for a table where the primary key is
> generated in part from sequence.
>
> How might this have happen?

Have any values been inserted that weren't obtained from the sequence?
What are the results of the following queries?

SELECT max(tid) FROM game_pay_cash_coupon_trans;
SELECT * FROM game_pay_cash_coupon_trans_seq;

(You already showed the second query, but let's see it again run at
the same time as the first).

--
Michael Fuhr