Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C5ACB64FD18
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 12 Aug 2008 10:57:16 -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 52725-09-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 12 Aug 2008 10:57:03 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.154])
	by postgresql.org (Postfix) with ESMTP id 50377650230
	for <pgsql-admin@postgresql.org>; Tue, 12 Aug 2008 10:56:55 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so1919215fgg.23
	for <pgsql-admin@postgresql.org>; Tue, 12 Aug 2008 06:56:53 -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:cc:in-reply-to:mime-version:content-type:references;
	bh=LGGO9030cb9/J4T03TmwLtz4Uc6bmtOo25MV6ADpyW8=;
	b=X3tT/M4TxRPOorMAvLhexJsiGOkIj01Qi+Oz76EW6KhlqCTGuiUZwAGyVEZzA/xPil
	ploesCa1q0zcZK4z/w7j1wfTfI1x5LtfXkV2M+xd1t0q92flH0E/qa5BeLL8kT/imP2/
	IV1TjQ8Uxx+fsSb/YEPD+vYmeSmi+nspeD/BA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=lTzJ00wSTp2KphzPm6F7gaXtdlQxC3hVhz08PCoksiBa3LTrLkPALtO1FNu0awjO7q
	KGhDoCztT+MZmKh9cOLzq+Ut2d5h3lRltZtb1rTxOHYHULTLJcegWJdlZ+DgrDgvGWb7
	XBZXCTDcTc6Q/sOthz6fGhVRFoPaIBpJ6BKP8=
Received: by 10.86.80.17 with SMTP id d17mr10311744fgb.33.1218549412954;
	Tue, 12 Aug 2008 06:56:52 -0700 (PDT)
Received: by 10.86.71.17 with HTTP; Tue, 12 Aug 2008 06:56:52 -0700 (PDT)
Message-ID: <3a0028490808120656h6c70fbd0q375160d7d86771@mail.gmail.com>
Date: Tue, 12 Aug 2008 10:56:52 -0300
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: subamathy <subamathy@gmail.com>
Subject: Re: Duplicate records in a table inspite of a primary key
Cc: pgsql-admin@postgresql.org
In-Reply-To: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_8579_22021373.1218549412963"
References: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
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/45
X-Sequence-Number: 29890

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

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 existing
>
>
> Could you pls help me out in finding the reson for duplicate records being
> inserted.
>

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

<div dir="ltr">Did you verified if isn&#39;t the software that is doing this?<br><br><div class="gmail_quote">2008/8/12 subamathy <span dir="ltr">&lt;<a href="mailto:subamathy@gmail.com">subamathy@gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir="ltr"><div>&nbsp;Hi,</div>
<div></div>
<table width="500">
<tbody><tr><td><div>We are having problems resulting from users being able to create duplicate records <br>in table.</div>
<div>&nbsp;</div>
<div>

&nbsp;Below is the description of the table</div>
</td></tr></tbody><tbody></tbody></table>
<table width="500"><tbody><tr><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) 
</td></tr></tbody><tbody></tbody></table>
<table width="500">
<tbody><tr><td><div>&nbsp;</div>
<div>

&nbsp;</div>
</td></tr></tbody><tbody></tbody></table>
<table width="500">
<tbody><tr><td><p>database version: PostgreSQL 8.0.1 
</p><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>
</td></tr></tbody><tbody></tbody></table>
<table width="500">
<tbody><tr><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>
</td></tr></tbody><tbody>
<td><div>&nbsp;</div></td></tbody></table>
<p>Could you pls help me out in finding the reson for duplicate records being inserted.</p></div>
</blockquote></div><br></div>

------=_Part_8579_22021373.1218549412963--