"Christian Meunier" <vchris@club-internet.fr> writes:
> When i insert a new tuple i use: insert into test values(nextval('test_num_=
> seq'),......);
> When i look at my postgres log, time to time i see:
> 2002-02-04 08:11:47 ERROR: Cannot insert a duplicate key into unique index=
> test_pkey
You sure that's the *only* way that the num column gets inserted or
updated?
regards, tom lane