Re: [GENERAL] Unique Indexes

2005-03-12 Thread ILove TheSpam
Could you describe the problem you're trying to solve? It might be easier to help if we knew the ultimate purpose of what you're trying to do. Something like "I want to do this because" Sure. Lets say I have 3 tables: surnames - surnameid serial (Primary Key), surname varchar (Unique) firstna

[GENERAL] Unique Indexes

2005-03-11 Thread ILove TheSpam
Hi, I'm new to Postgres and plpgsql so my sincerest apologies if the answer to my problem is common :-) I want to add entries to a table. The table has 2 fields, FieldID which is the primary key and FieldValue which is a unique field. I can add to FieldValue just fine when the unique constraint h