Displaying 2 results from an estimated 2 matches for "if6ktzujmz25d".
2019 May 19
2
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...s at least for the very first login of a user but it looks like Dict always want to add a new record into my last_login table instead of updating the existing record for a specific user. 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. O...
2019 May 19
0
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...t for the very first login of a user but it looks like Dict always want to add a new record into my last_login table instead of updating the existing record for a specific user. 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...