Displaying 2 results from an estimated 2 matches for "createrul".
Did you mean:
createmul
2019 May 19
0
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...ay be able to find a workaround, by redefining the table without a
primary key and then select the max(last_login) from the table, with
some periodic job that clears out the old entries.
Or you could make a workaround with the rules syntax from PostgresSql.
https://www.postgresql.org/docs/9.2/sql-createrule.html
Though probably the best thing is a patch to dovecot in order to support
last_login for PostgresSql.
John
2019 May 19
4
Dict issue with PostgreSQL for last_login plugin (duplicate key)
??????? Original Message ???????
On Sunday, May 19, 2019 2:58 PM, John Fawcett via dovecot <dovecot at dovecot.org> wrote:
> I guess it is not supported for PostgreSQL or Sqlite, since they don't
> have "ON DUPLICATE KEY UPDATE" statement which is what is being used in
> MySQL.
That's it, PostgreSQL does not have "ON DUPLICATE KEY" but instead uses