On 15 Jan 2011, at 23:52, Randall Smith wrote: > Hi, > > I've created a trigger that checks the uniqueness of two columns in a > table. Traditionally, one would use a unique constraint, but in my > case, the size of the unique index would be too large and some > performance loss is acceptable.
But you already do have an index on that id-field, so what's the problem with using a unique constraint? Its unique index could just replace the existing one. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4d323b1e11871071717716! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
