From: subamathy <subamathy@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Duplicate records in a table inspite of a primary key
Date: Tue, 12 Aug 2008 12:17:58 +0530
Message-ID: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com> (raw)
Hi,
We are having problems resulting from users being able to create duplicate
records
in table.
Below is the description of the table
Column | Type | Modifiers
-----------------------+------------------------+-----------
user_id | character varying(128) | not null
person_email_required | numeric(5,0) |
wddx_data | text |
proxy_id | character varying(128) |
email_to | character varying(6) |
password | character varying(60) |
user_name | character varying(64) |
language_preference | character varying(20) |
enable_autosearch | character varying(6) |
country_id | character varying(16) |
Indexes:
"i_personalise" PRIMARY KEY, btree (user_id)
"i_personalise_proxy_id" btree (proxy_id)
"i_personalise_user_id" btree (user_id)
database version: PostgreSQL 8.0.1
i_personalise- index
conn type: Primary (constriant Type)
condeferrable: False
conkey: 1 (column which has constraint)
Could you please help me out in finding the reason for such dupicate records
existing
Could you pls help me out in finding the reson for duplicate records being
inserted.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: subamathy@gmail.com
Subject: Re: Duplicate records in a table inspite of a primary key
In-Reply-To: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox