From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: subamathy <subamathy@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Duplicate records in a table inspite of a primary key
Date: Tue, 12 Aug 2008 10:56:52 -0300
Message-ID: <3a0028490808120656h6c70fbd0q375160d7d86771@mail.gmail.com> (raw)
In-Reply-To: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
References: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, subamathy@gmail.com
Subject: Re: Duplicate records in a table inspite of a primary key
In-Reply-To: <3a0028490808120656h6c70fbd0q375160d7d86771@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox