It appears that you have run the contacts package install SQL scripts more than once on the same database.
One way to attempt to fix it is to run the drop script under /contacts/sql/postgresql/contacts-drop.sql
This should remove the data model. If you do that you should then be able to uninstall contacts and try again.
If you do not want to uninstall contacts the other option is to look at contacts-create.sql and run that script plus any scripts referred to in contacts-create.sql manually.
This will ensure all the scripts are run.
Then, if you are attempting to install the contacts package you'll need to go to acs-admin/apm/ and click Install Packages, choose contacts, then after you click the "Choose Data Model Scripts" button UNCHECK all the contacts SQL files. This will install the package without running the SQL again and should avoid those errors.