[ADMIN] Duplicate records in a table inspite of a primary key

2008-08-12 Thread subamathy
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 |

Re: [ADMIN] Duplicate records in a table inspite of a primary key

2008-08-12 Thread Rafael Domiciano
Did you verified if isn't the software that is doing this? 2008/8/12 subamathy [EMAIL PROTECTED] 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

Re: [ADMIN] Duplicate records in a table inspite of a primary key

2008-08-12 Thread Julius Tuskenis
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

Re: [ADMIN] Duplicate records in a table inspite of a primary key

2008-08-12 Thread Robert Treat
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 |

Re: [ADMIN] Duplicate records in a table inspite of a primary key

2008-08-12 Thread Rex Mabry
You have to be careful when using characters as your PK.  A trailing space could give the appearance of duplicate keys. Example: user1 user1 (This one has a space at the end) --- On Tue, 8/12/08, Robert Treat [EMAIL PROTECTED] wrote: From: Robert Treat [EMAIL PROTECTED] Subject: Re: [ADMIN]