Date: Tue, 12 Aug 2008 10:27:53 -0400
From: Robert Treat <xzilla@users.sourceforge.net>
Subject: Re: Duplicate records in a table inspite of a primary key
In-reply-to: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
To: pgsql-admin@postgresql.org
Cc: subamathy <subamathy@gmail.com>
Message-id: <200808121027.53405.xzilla@users.sourceforge.net>
MIME-version: 1.0
Content-type: text/plain; charset=iso-8859-15
Content-transfer-encoding: 7bit
Content-disposition: inline
References: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
User-Agent: KMail/1.9.9

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