Re: [Dovecot] Wiki entry for expire plugin, PostgreSQL trigger needs update

2009-08-09 Thread Stefan Förster
* Stefan Förster : > The wiki entry at http://wiki.dovecot.org/Plugins/Expire needs an > update for Dovecot 1.2 and PostgreSQL: NVM. Seems everyone can change wiki pages.

[Dovecot] Wiki entry for expire plugin, PostgreSQL trigger needs update

2009-08-09 Thread Stefan Förster
The wiki entry at http://wiki.dovecot.org/Plugins/Expire needs an update for Dovecot 1.2 and PostgreSQL: -- v1.2+: CREATE OR REPLACE FUNCTION merge_expires() RETURNS TRIGGER AS $$ BEGIN IF exists(SELECT 1 FROM expires WHERE username = NEW.username AND mailbox = NEW.mailbox) THEN UPDATE expi