Re: Prevent double entries ... no simple unique index

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Prevent double entries ... no simple unique index
Date: 2012-07-11 09:11:06
Message-ID: CAFnxYwhSjbyCerkWkaWJD61p=T7WYVTP1t9zVaO46Yr0CSE-sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jul 11, 2012 at 12:50 AM, Andreas <maps(dot)on(at)gmx(dot)net> wrote:

[...]

> I can't simply move rejected events in an archive table and keep a unique
> index on object_id as there are other descriptive tables that reference the
> event_log.id.

Would a multi-column index, unique on (id, state) meet your need?

rls

--
:wq

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marc Mamin 2012-07-11 10:53:52 Re: Prevent double entries ... no simple unique index
Previous Message Andreas Kretschmer 2012-07-11 08:24:58 Re: Prevent double entries ... no simple unique index