Postgres Pro
Downloads
Home   >   mailing lists

Duplicate primary keys - Mailing list pgsql-novice

From Jason Tan Boon Teck
Subject Duplicate primary keys
Date
Msg-id dd8f6c970801171833k4a33d40byfcf9f3ba00bf0e04@mail.gmail.com
Whole thread Raw
Responses Re: Duplicate primary keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
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.


TIA.

--
Jason Tan Boon Teck

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: domains, types, constraints
Next
From: Tom Lane
Date:
Subject: Re: Duplicate primary keys