Folks,
I had a problem with my data structure.
Basically I had unique user_idnr values but non-unique userid values.
This led to strange problems (mails disappearing all of a sudden and so
forth).
Maybe userid should be unique.
We are using dbmail 1.2
dbmail=# \d users
Table "public.users"
Column | Type |
Modifiers
-----------------+-----------------------------+-------------------------------------------------
user_idnr | bigint | not null default
nextval('user_idnr_seq'::text)
userid | character varying(100) | not null
passwd | character varying(34) | not null
client_idnr | bigint | not null default '0'
maxmail_size | bigint | not null default '0'
encryption_type | character varying(20) | not null default ''
last_login | timestamp without time zone | not null default
'1979-11-03 22:05:58'
Indexes: users_pkey primary key btree (user_idnr),
users_id_idx unique btree (user_idnr),
users_name_idx btree (userid)
Cheers,
Hans
