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