diff options
| author | LazyDBA247-Anyvision <yonin@anyvision.co> | 2021-03-30 10:21:27 +0300 |
|---|---|---|
| committer | LazyDBA247-Anyvision <yonin@anyvision.co> | 2021-03-30 10:21:27 +0300 |
| commit | 9f1cab179c1c41deb1db627e8bfbc632a2dffba7 (patch) | |
| tree | 7b91631886439992712baf6faa3f2590a925308f /weed/command | |
| parent | 7f44d953b56dc74281b6de3dcac184d97c9715f1 (diff) | |
| download | seaweedfs-9f1cab179c1c41deb1db627e8bfbc632a2dffba7.tar.xz seaweedfs-9f1cab179c1c41deb1db627e8bfbc632a2dffba7.zip | |
use a compatible pg syntax for upsert
Diffstat (limited to 'weed/command')
| -rw-r--r-- | weed/command/scaffold.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/weed/command/scaffold.go b/weed/command/scaffold.go index babcdcdc7..7df69e211 100644 --- a/weed/command/scaffold.go +++ b/weed/command/scaffold.go @@ -168,7 +168,7 @@ connection_max_idle = 100 connection_max_open = 100 connection_max_lifetime_seconds = 0 # if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: -upsertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT ON CONSTRAINT "%[1]s_pkey" DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" +upsertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT (dirhash,name) DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" enableUpsert = true [postgres2] |