Re: Can't add records

From: Chris Smith <csmith(at)squiz(dot)net>
To: Setyo Nugroho <snugroho(at)gmx(dot)net>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Can't add records
Date: 2002-11-13 21:35:39
Message-ID: 5.1.0.14.0.20021114083327.02675690@cooee.squiz.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...../>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Smith 2002-11-13 22:31:02 Re: Describe a table
Previous Message Josh Berkus 2002-11-13 18:49:44 Re: Can't add records