Re: Problem when adding an existing primary key

Ricardo,

> When I try to insert via application a registry that already exists
> Postgres shows an error "Unable to insert duplicate primary key on index
> 'index' ". I think it's an error, because I would treat this error, just
> like others.

You're getting that message becuase you are trying to insert a value into the
PK column which is a duplicate of a value already present. This is not
permitted ... definitionally, primary keys must be unique.

In other words, the above is a valid error message being sent to you because
you violated a table constraint.

If there is more to the story than that, I suggest that you post your problems
to the PGSQL-NOVICE mailing list, where other users will help you fix your
queries. For that matter, I believe that there are other Brazillians on some
of the other mailing lists (you could try PGSQL-GENERAL as well), which would
spare you the pain of translating your questions.

--
Josh Berkus
Aglio Database Solutions
San Francisco