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

From Josh Berkus
Subject Re: Can't add records
Date
Msg-id 200211131049.44988.josh@agliodbs.com
Whole thread Raw
In response to Can't add records  (Setyo Nugroho <snugroho@gmx.net>)
List pgsql-novice
Setyo,

> "QPSQL:unable to create query.
> Error: cannot insert a duplicate key into unique index route_pkey."

> What does the above-mentioned error message mean?
> How to fix the problem?

It means that you are trying to insert a dumplicate RouteID into the table,
which is rejected because it's a violation of your primary key (RouteID).

I can think of several reasons why this would happen.   How is your interface
getting new values for the RouteID column?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-novice by date:

Previous
From: Setyo Nugroho
Date:
Subject: Can't add records
Next
From: Chris Smith
Date:
Subject: Re: Can't add records