From: Julius Tuskenis <julius@nsoft.lt>
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 17:05:08 +0300
Message-ID: <48A19894.60601@nsoft.lt> (raw)
In-Reply-To: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
References: <b7d13ee10808112347o33ece150u543615eec78e3a8@mail.gmail.com>
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
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: julius@nsoft.lt, subamathy@gmail.com
Subject: Re: Duplicate records in a table inspite of a primary key
In-Reply-To: <48A19894.60601@nsoft.lt>
* 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