[Dovecot] expire plugin with pgsql not working

[Timo Sirainen]

On Tue, 2008-12-23 at 07:43 +0100, LÉVAI Dániel wrote:
> Timo Sirainen wrote:
> > On Dec 22, 2008, at 3:10 AM, LÉVAI Dániel wrote:
> > 
> >> I've configured dovecot, and created the db/table/trigger according to
> >> http://wiki.dovecot.org/Quota/Dict.
> > 
> > Look into http://wiki.dovecot.org/Plugins/Expire instead. Although I 
> > just had to fix that page too.
> > 
> Right, now I see. You've removed the username column from the CREATE
> TABLE statement. But why did you only remove it from the "v1.1 only"
> section? v1.2+ needs it?

Yes. v1.2 configuration is different.

> Also, from the "dovecot-dict-expire.conf: " section, where there is an
> example config, the username field is still there, 

I changed that a day or two ago.

> and under the
> "PostgreSQL Backend" section the trigger still has the username in the
> IF test and the UPDATE's expression.
> Do you think these should be edited as well?

Updated.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20090109/53bc48fd/attachment-0001.bin