diff options
Diffstat (limited to 'auth_mtpostgresql.go')
| -rw-r--r-- | auth_mtpostgresql.go | 2 |
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 } |