Clojurians Log v2
Clojure programming
Channels
Apps
onyx
FYI: alternative Onyx :onyx: chat is at <https://gitter.im/onyx-platform/onyx> ; log can be found at <https://clojurians-log.clojureverse.org/onyx/index.html>
niamu 2018-01-18T20:14:48.000283Z
I’ve been attempting to use the onyx-sql plugin with the task upsert-rows on a Postgres database and I don’t think it supports it.
niamu 2018-01-18T20:15:29.000569Z
I’m not a database expert, so maybe there’s something I’m missing, but from what I understand, Postgres requires some extra “ON CONFLICT” portions in the query to support upserting.
niamu 2018-01-18T20:15:58.000214Z
Seems like maybe this has never been addressed in the onyx-sql plugin.
lucasbradstreet 2018-01-18T20:16:39.000745Z
Ah, that was recent user contributed functionality, so we won’t be able to provide much in the way of information there.
lucasbradstreet 2018-01-18T20:16:52.000142Z
If you can find a way to make it support both (possibly with a flag), that’d be great.
niamu 2018-01-18T20:17:40.000533Z
My current plan was checking for the subprotocol of the sql-settings and if it is “postgresql” make the changes to the query necessary.
lucasbradstreet 2018-01-18T20:30:13.000796Z
That’d be fine 🙂