Re: Bug with sequence ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug with sequence ?
Date
Msg-id 6397.1012839669@sss.pgh.pa.us
Whole thread Raw
In response to Bug with sequence ?  ("Christian Meunier" <vchris@club-internet.fr>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Christian Meunier"
Date:
Subject: Bug with sequence ?
Next
From: bpalmer
Date:
Subject: Re: v7.2 rolled last night ...