Displaying 2 results from an estimated 2 matches for "last_logins_pkey".
2019 May 19
2
Dict issue with PostgreSQL for last_login plugin (duplicate key)
.... Here is the error message from Dovecot:
May 19 12:45:14-mbox1 dovecot: imap(user at domain.tld)<51915><if6KTzuJMZ25D+Vc>: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: ERROR: duplicate key value violates unique constraint "last_logins_pkey"
It looks like Dict with PostgreSQL does not support UPDATEing an already existing record in the table. Or am I missing something? or it does not work with PostgreSQL? Which does not make much sense to me...
Regards,
Mabi
2019 May 19
0
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...the error message from Dovecot:
>
> May 19 12:45:14-mbox1 dovecot: imap(user at domain.tld)<51915><if6KTzuJMZ25D+Vc>: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: ERROR: duplicate key value violates unique constraint "last_logins_pkey"
>
> It looks like Dict with PostgreSQL does not support UPDATEing an already existing record in the table. Or am I missing something? or it does not work with PostgreSQL? Which does not make much sense to me...
>
> Regards,
> Mabi
>
I guess it is not supported for PostgreSQL...