I was performing a reindex yesterday when it failed stating a duplicate primary key violation. I looked into the database and found 3 tables with duplicate rows.
How reliable is PostgreSQL in *preventing* rows duplicate primary keys to be inserted? I am not using any table inheritance and the db is ver 8.1.1 from Debian Etch. The db is used by a PHP app.