fix UPSERTion of postgres users / passwords

1 files changed, 1 insertions, 1 deletions

diff --git a/auth_mtpostgresql.go b/auth_mtpostgresql.go
index ffd932c..fe4b9c7 100644
--- a/auth_mtpostgresql.go
+++ b/auth_mtpostgresql.go
@@ -134,7 +134,7 @@ func (a *AuthMTPostgreSQL) Passwd(name string) (salt, verifier []byte, err error
 func (a *AuthMTPostgreSQL) SetPasswd(name string, salt, verifier []byte) error {
 	encodedPasswd := encodeVerifierAndSalt(salt, verifier)
 
-	_, err := a.db.Exec("REPLACE INTO auth (name, password, last_login) VALUES ($1, $2, unixepoch());", name, encodedPasswd)
+	_, err := a.db.Exec("INSERT INTO auth (name, password, last_login) VALUES ($1, $2, extract(epoch from now())) ON CONFLICT (name) DO UPDATE SET password = EXCLUDED.password, last_login = extract(epoch from now());", name, encodedPasswd)
 	return err
 }