On Wed, Jul 11, 2012 at 12:50 AM, Andreas <maps.on@gmx.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