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.

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.

Seems like maybe this has never been addressed in the onyx-sql plugin.

Ah, that was recent user contributed functionality, so we won’t be able to provide much in the way of information there.

If you can find a way to make it support both (possibly with a flag), that’d be great.

My current plan was checking for the subprotocol of the sql-settings and if it is “postgresql” make the changes to the query necessary.

That’d be fine 🙂