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 обсуждение исходный текст |
Ответы |
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>) Re: Duplicate records in a table inspite of a primary key (Robert Treat <xzilla@users.sourceforge.net>) |
Список | pgsql-admin |
Hi,
We are having problems resulting from users being able to create duplicate records in 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"Дата:
Сообщение: Re: Duplicate records in a table inspite of a primary key