Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2E9C864FCD9
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 12 Aug 2008 03:48:04 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 63297-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 12 Aug 2008 03:47:58 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fk-out-0910.google.com (fk-out-0910.google.com
 [209.85.128.184])
	by postgresql.org (Postfix) with ESMTP id 5D3EB64FCC9
	for <pgsql-admin@postgresql.org>; Tue, 12 Aug 2008 03:48:00 -0300 (ADT)
Received: by fk-out-0910.google.com with SMTP id e30so2594339fke.3
	for <pgsql-admin@postgresql.org>; Mon, 11 Aug 2008 23:47:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=0F1ad1HpWU2FDGYsF+MllnE1bGOnZccZ6ihJ+hveHIQ=;
	b=trT0lANksTu5gAmldncpuBy43C68ib0AoXzbpTnMWP/L8OUbe+vp34tiKisEL1RryZ
	vgO/8Dgy71/F/ZKG2My2wVuGaCQVOOaInpKwC02FZJWLFPM3Q1Lq5sXv3b5dex6NRB6A
	8ZXNyTif4QNxHzf7zhVyvVOhzTU34il4tzD58=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=k6BvP54moKxdGzjx7SvLwcXyKxLUJCaF/hzKRNtTEoNMc+VVBCm5pCW+VpDe0nJqgx
	NfEx+Ge9v+YDZeV6NgwjaF5cQ5nM9YjtnTcGyZdvdSmk8TIPfmylTYSjQa/ok7JsVKC+
	xbdY39FeeF4vPxT4ZT4jK67imSphkKctaS3rg=
Received: by 10.180.239.8 with SMTP id m8mr4353564bkh.48.1218523678776;
	Mon, 11 Aug 2008 23:47:58 -0700 (PDT)
Received: by 10.180.254.11 with HTTP; Mon, 11 Aug 2008 23:47:58 -0700 (PDT)
Message-ID: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
Date: Tue, 12 Aug 2008 12:17:58 +0530
From: subamathy <subamathy@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Duplicate records in a table inspite of a primary key
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_24545_10403842.1218523678746"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/44
X-Sequence-Number: 29889

------=_Part_24545_10403842.1218523678746
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

 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.

------=_Part_24545_10403842.1218523678746
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr"><div>&nbsp;Hi,</div>
<div></div>
<table width="500">
<td><div>We are having problems resulting from users being able to create duplicate records <br>in table.</div>
<div>&nbsp;</div>
<div>
<style type="text/css">
body { margin: 0 0 0 0; padding:0 0 0 0 }
td,div { font-family:Tahoma;font-size:8pt;vertical-align:top }
body { margin: 0 0 0 0; padding:0 0 0 0 }
.transcript { background-color:#d2d2d2; }
.messageBlock { margin-left:4px; margin-bottom:3px }
.message { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre; }
.messageCont { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre;}
.other { color:#39577a;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.myself { color:#da8103;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont { font-size:8px;text-align:right; color:#39577a;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.myselfCont { font-size:8px;text-align:right; color:#da8103;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.system { margin-left:4px; word-wrap:break-word;color:#da8103;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; _white-space:pre; }
.showTimestamp { margin-right:3px; float:right; color:#999999;font-style:normal;font-weight:normal; }
.other1 { color:#ac2000;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont1 { font-size:8px;text-align:right; color:#ac2000;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other2 { color:#3c9fa8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont2 { font-size:8px;text-align:right; color:#3c9fa8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other3 { color:#e25614;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont3 { font-size:8px;text-align:right; color:#e25614;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other4 { color:#0b6ac8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont4 { font-size:8px;text-align:right; color:#0b6ac8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other5 { color:#b23290;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont5 { font-size:8px;text-align:right; color:#b23290;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other6 { color:#02e7c7;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont6 { font-size:8px;text-align:right; color:#02e7c7;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other7 { color:#5b3284;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont7 { font-size:8px;text-align:right; color:#5b3284;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.tsDisplay { display:block }</style>
&nbsp;Below is the description of the table</div>
<tbody></tbody></td></table>
<table width="500"><td>Column | Type | Modifiers<br>-----------------------+------------------------+-----------<br>user_id | character varying(128) | not null<br>person_email_required | numeric(5,0) |<br>wddx_data | text |<br>
proxy_id | character varying(128) |<br>email_to | character varying(6) |<br>password | character varying(60) |<br>user_name | character varying(64) |<br>language_preference | character varying(20) |<br>enable_autosearch | character varying(6) |<br>
country_id | character varying(16) |<br>Indexes:<br>&quot;i_personalise&quot; PRIMARY KEY, btree (user_id)<br>&quot;i_personalise_proxy_id&quot; btree (proxy_id)<br>&quot;i_personalise_user_id&quot; btree (user_id) 
<tbody></tbody></td></table>
<table width="500">
<td><div>&nbsp;</div>
<div>
<style type="text/css">
body { margin: 0 0 0 0; padding:0 0 0 0 }
td,div { font-family:Tahoma;font-size:8pt;vertical-align:top }
body { margin: 0 0 0 0; padding:0 0 0 0 }
.transcript { background-color:#d2d2d2; }
.messageBlock { margin-left:4px; margin-bottom:3px }
.message { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre; }
.messageCont { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre;}
.other { color:#39577a;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.myself { color:#da8103;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont { font-size:8px;text-align:right; color:#39577a;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.myselfCont { font-size:8px;text-align:right; color:#da8103;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.system { margin-left:4px; word-wrap:break-word;color:#da8103;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; _white-space:pre; }
.showTimestamp { margin-right:3px; float:right; color:#999999;font-style:normal;font-weight:normal; }
.other1 { color:#ac2000;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont1 { font-size:8px;text-align:right; color:#ac2000;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other2 { color:#3c9fa8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont2 { font-size:8px;text-align:right; color:#3c9fa8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other3 { color:#e25614;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont3 { font-size:8px;text-align:right; color:#e25614;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other4 { color:#0b6ac8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont4 { font-size:8px;text-align:right; color:#0b6ac8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other5 { color:#b23290;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont5 { font-size:8px;text-align:right; color:#b23290;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other6 { color:#02e7c7;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont6 { font-size:8px;text-align:right; color:#02e7c7;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other7 { color:#5b3284;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont7 { font-size:8px;text-align:right; color:#5b3284;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.tsDisplay { display:block }</style>
&nbsp;</div>
<tbody></tbody></td></table>
<table width="500">
<td><p>database version: PostgreSQL 8.0.1 
<p></p>
<p>i_personalise- index</p>
<p>conn type: Primary (constriant Type)<br>condeferrable: False<br>conkey: 1 (column which has constraint)&nbsp;</p>
<tbody></tbody></p></td></table>
<table width="500">
<td><div></div>
<div>&nbsp;</div>
<div>Could you please help me out in finding the reason for such dupicate records existing</div>
<div></div>
<tbody>
<div>&nbsp;</div></tbody></td></table>
<p>Could you pls help me out in finding the reson for duplicate records being inserted.</p></div>

------=_Part_24545_10403842.1218523678746--