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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
