Displaying 6 results from an estimated 6 matches for "has_on_duplicate_key".
2019 May 19
3
Dict issue with PostgreSQL for last_login plugin (duplicate key)
On 19/05/2019 20:31, mabi via dovecot wrote:
>
> ??????? Original Message ???????
> On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot
> <dovecot at dovecot.org> wrote:
>>
>> Attached is a tentative patch. I've verified no regression for mysql.
>> There should be no regression for sqlite as the code path is identical.
>>
>> Are you able to
2019 May 19
0
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...0519/b0ab52cc/attachment.html>
-------------- next part --------------
--- dict-sql-private.h.orig 2019-05-19 19:00:12.395887496 +0200
+++ dict-sql-private.h 2019-05-19 19:04:00.147601310 +0200
@@ -13,6 +13,7 @@
HASH_TABLE(const char *, struct sql_prepared_statement *) prep_stmt_hash;
bool has_on_duplicate_key:1;
+ bool has_on_conflict_do_update:1;
};
#endif
--- dict-sql.c.orig 2019-05-19 18:58:02.435194691 +0200
+++ dict-sql.c 2019-05-19 19:17:52.613253822 +0200
@@ -105,8 +105,10 @@
i_zero(&sql_set);
sql_set.driver = driver->name;
sql_set.connect_string = dict->set->connect;
- /*...
2019 May 19
2
Dict issue with PostgreSQL for last_login plugin (duplicate key)
On 19/05/2019 16:25, John Fawcett via dovecot wrote:
> INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld','domain.tld')
I don't have PostgresSql, would you be able to verify if this syntax would work:
INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld','domain.tld')
2019 May 19
2
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...cfd5cdd2/attachment-0001.html>
-------------- next part --------------
--- dict-sql-private.h.orig 2019-05-19 19:00:12.395887496 +0200
+++ dict-sql-private.h 2019-05-19 19:04:00.147601310 +0200
@@ -13,6 +13,7 @@
HASH_TABLE(const char *, struct sql_prepared_statement *) prep_stmt_hash;
bool has_on_duplicate_key:1;
+ bool has_on_conflict_do_update:1;
};
#endif
--- dict-sql.c.orig 2019-05-19 18:58:02.435194691 +0200
+++ dict-sql.c 2019-05-19 19:17:52.613253822 +0200
@@ -105,8 +105,10 @@
i_zero(&sql_set);
sql_set.driver = driver->name;
sql_set.connect_string = dict->set->connect;
- /*...
2019 May 19
4
Dict issue with PostgreSQL for last_login plugin (duplicate key)
...6d0f6850/attachment-0001.html>
-------------- next part --------------
--- dict-sql-private.h.orig 2019-05-19 19:00:12.395887496 +0200
+++ dict-sql-private.h 2019-05-19 19:04:00.147601310 +0200
@@ -13,6 +13,7 @@
HASH_TABLE(const char *, struct sql_prepared_statement *) prep_stmt_hash;
bool has_on_duplicate_key:1;
+ bool has_on_conflict_do_update:1;
};
#endif
--- dict-sql.c.orig 2019-05-19 18:58:02.435194691 +0200
+++ dict-sql.c 2019-05-20 00:25:56.558251260 +0200
@@ -105,8 +105,10 @@
i_zero(&sql_set);
sql_set.driver = driver->name;
sql_set.connect_string = dict->set->connect;
- /*...
2010 Mar 25
4
quota dict with mysql 4.0
Hello,
i use successfully mysql-quotasystem with dovecot 1.2.11 on different
servers except for mysql 4.0 servers
dovecot internally uses sql: "ON DUPLICATE KEY UPDATE" which was introduced
in mysql 4.1
Is there a chance to make this statement mysql 4.0 compatible or should i
update mysql? i want to avoid updating mysql because some old software is
running which is not compatible to