Duplicate records in a table inspite of a primary key
От
subamathy
Тема
Duplicate records in a table inspite of a primary key
Дата
Msg-id
b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com
Список
Дерево обсуждения
Duplicate records in a table inspite of a primary key subamathy <subamathy@gmail.com>
Re: Duplicate records in a table inspite of a primary key Robert Treat <xzilla@users.sourceforge.net>
Re: Duplicate records in a table inspite of a primary key Rex Mabry <rexmabry@yahoo.com>
Re: Duplicate records in a table inspite of a primary key "Rafael Domiciano" <rafael.domiciano@gmail.com>
Re: Duplicate records in a table inspite of a primary key Julius Tuskenis <julius@nsoft.lt>
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) |
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.
В списке pgsql-admin по дате отправления
От: Rafael Domiciano
Дата:
