dovecot - Dec 2008 - expire plugin with pgsql not working

Hi!

I've configured dovecot, and created the db/table/trigger according to 
http://wiki.dovecot.org/Quota/Dict. I'm using dovecot-1.1.7 and pgsql. 
When moving a message inside the "monitored" directory, the expires 
table won't get updated because of an error:

statement: INSERT INTO expires (expire_stamp, mailbox) VALUES 
('1229993423', 'leva/spamassassin.SPAM')
INSERT ERROR:  null value in column "username" violates not-null 
constraint

Wonder why doesn't dovecot pass the username too. What could be the 
problem?

Daniel

-- 
LEVAI Daniel
PGP key ID = 0x4AC0A4B1
Key fingerprint = D037 03B9 C12D D338 4412  2D83 1373 917A 4AC0 A4B1

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.
> statement: INSERT INTO expires (expire_stamp, mailbox) VALUES
> ('1229993423', 'leva/spamassassin.SPAM')
> INSERT ERROR:  null value in column "username" violates not-null
> constraint
>
> Wonder why doesn't dovecot pass the username too. What could be the
> problem?
It doesn't need to have a username field. Leave it out of the primary  
key (and remove the entire field).