Re: [Dovecot] expire plugin: columns not uniq

Search the Wiki about Postgres and the requirement of a TRIGGER. I guess that sqlite requires something like this.

Maybe someone family with sqlite will say how to make this trigger better and constrain check field existence before doing UPDATE

CREATE TRIGGER mergeexpire BEFORE INSERT ON expires FOR EACH ROW BEGIN UPDATE expires SET expire_stamp=NEW.expire_stamp WHERE username = NEW.username AND mailbox = NEW.mailbox; SELECT raise(ignore) WHERE (SELECT 1 FROM expires WHERE username = NEW.username AND mailbox = NEW.mailbox) IS NOT NULL; END;

This seem some kind crudely to me, but it's working.