Postgres Pro
Downloads
Home   >   mailing lists

Re: UNIQUE on everything except primary key - Mailing list pgsql-sql

From msi77
Subject Re: UNIQUE on everything except primary key
Date
Msg-id 448911296802962@web71.yandex.ru
Whole thread Raw
In response to UNIQUE on everything except primary key  (gvim <gvimrc@gmail.com>)
List pgsql-sql
Tree view 
Do all the 10 columns make a natural key?

03.02.2011, 18:44, "gvim" <gvimrc@gmail.com>:
> I have a table with 11 columns and want to eliminate duplication on INSERTs. What's the best method? The obvious
solutionwould be to create a UNIQUE index on everything except the primary key - 'id' - but that's a 10-column index
anddoesn't sound very efficient. Am I missing something more obvious?
 
>
> gvim
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: using of select (myfunction()).* is so slow
Next
From: creationw
Date:
Subject: How to checking the existance of constraints for a table?