Обсуждение: Duplicate records in a table inspite of a primary key
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.
Did you verified if isn't the software that is doing this?
2008/8/12 subamathy <subamathy@gmail.com>
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 existingCould you pls help me out in finding the reson for duplicate records being inserted.
Hello, please send a sql script that was used to create this table. If you use pgAdmin you can copy the sql from it. By saying dublicate records you mean identical? That is there are records with the same user_id value? subamathy rašė: > 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. > -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
On Tuesday 12 August 2008 02:47:58 subamathy wrote: > 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. I'm pretty sure that between 8.0.1 and 8.0.17 there are a couple of bugfixes related to duplicate rows with pk scenarios, you should probably take some time to upgrade before you spend too much time digging into this (make sure to read all of the release notes for those versions in between, i'm also thinking there are some special instructions that might need to be done somewhere in there) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
You have to be careful when using characters as your PK. A trailing space could give the appearance of duplicate keys. Example: "user1" "user1 " (This one has a space at the end) --- On Tue, 8/12/08, Robert Treat <xzilla@users.sourceforge.net> wrote: From: Robert Treat <xzilla@users.sourceforge.net> |