diff options
| author | Grant Limberg <[email protected]> | 2022-06-19 18:09:28 -0700 |
|---|---|---|
| committer | GitHub <[email protected]> | 2022-06-19 18:09:28 -0700 |
| commit | caf8b15f6d002f8446b84ed964dbe5374fe989cf (patch) | |
| tree | e413248f130b6b0e035c9b8847b86d954688d141 /controller/PostgreSQL.cpp | |
| parent | 355d3f44fb47492b5b40c44156d2798112e63d7c (diff) | |
| parent | bc7f18064f4eb8c4a1d13a5fc3db47416e950dab (diff) | |
Merge pull request #1701 from tossp/sql2
fix sql
Diffstat (limited to 'controller/PostgreSQL.cpp')
| -rw-r--r-- | controller/PostgreSQL.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/controller/PostgreSQL.cpp b/controller/PostgreSQL.cpp index 8705ba86..0d3c6169 100644 --- a/controller/PostgreSQL.cpp +++ b/controller/PostgreSQL.cpp @@ -1358,7 +1358,7 @@ void PostgreSQL::commitThread() "$1, TO_TIMESTAMP($5::double precision/1000), " "(SELECT user_id AS owner_id FROM ztc_global_permissions WHERE authorize = true AND del = true AND modify = true AND read = true LIMIT 1)," "$2, $3, $4, TO_TIMESTAMP($5::double precision/1000), " - "$6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, 17) " + "$6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) " "ON CONFLICT (id) DO UPDATE set controller_id = EXCLUDED.controller_id, " "capabilities = EXCLUDED.capabilities, enable_broadcast = EXCLUDED.enable_broadcast, " "last_modified = EXCLUDED.last_modified, mtu = EXCLUDED.mtu, " |