diff options
| author | Chris Lu <chrislusf@users.noreply.github.com> | 2021-03-30 01:01:59 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-03-30 01:01:59 -0700 |
| commit | 48188abc7b555a579cec0d93af47ba5c0caa6fcc (patch) | |
| tree | 23dfe150ce6c9335d8d8f4386450fedcc19355d4 | |
| parent | e5164a3c34011457cec7cac8be3e87ffeb6518dd (diff) | |
| parent | 9385e2224da32378eff633ed2b0f4d209a0e834d (diff) | |
| download | seaweedfs-48188abc7b555a579cec0d93af47ba5c0caa6fcc.tar.xz seaweedfs-48188abc7b555a579cec0d93af47ba5c0caa6fcc.zip | |
Merge pull request #1952 from LazyDBA247-Anyvision/master
fix postgres2 upsertQuery syntax also
| -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 668bb1b0d..4794da18e 100644 --- a/weed/command/scaffold.go +++ b/weed/command/scaffold.go @@ -194,7 +194,7 @@ 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: enableUpsert = true -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""" [cassandra] # CREATE TABLE filemeta ( |