Re: Can't add records - Mailing list pgsql-novice

From Chris Smith
Subject Re: Can't add records
Date
Msg-id 5.1.0.14.0.20021114083327.02675690@cooee.squiz.net
Whole thread Raw
In response to Can't add records  (Setyo Nugroho <snugroho@gmx.net>)
List pgsql-novice
Hi,

>Hi all,
>
>Wrote a small program using Qt. After some tests with another database,
>usingthe very same program, I found something erroneous in my program.
>- editing & deleting records: OK
>- adding records: NO
>I got this eror message:
>
>"QPSQL:unable to create query.
>Error: cannot insert a duplicate key into unique index route_pkey."

Your script is trying to insert a value that is already there.

In your table you have values 1,2,3,4,5.

Your script is trying to insert one of these values in again and giving the
error.

Chris Smith


 >> 92 Jarrett St Leichhardt, Sydney, NSW 2040 ...>
T: + 61 2 9568 6866
F: + 61 2 9568 6733
W: http://www.squiz.net/
.....>> Open Source - Own it - Squiz.net ...../>


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Can't add records
Next
From: Chris Smith
Date:
Subject: Re: Describe a table