Postgres [supports](https://www.postgresql.org/docs/9.5/static/sql-insert.html) an extension of `INSERT ... ON CONFLICT` where a constraint name is given instead of a set of columns. We currently don't support this, but we should: https://github.com/cockroachdb/cockroach/blob/07d85bd1eef62a78d5be2ac9e7574db88c88e35c/pkg/sql/parser/sql.y#L4808 This would have been a solution for #27981 if we supported it. cc. @knz for triage. Perhaps @emsal1863 would be interested in working on this?
Postgres supports an extension of
INSERT ... ON CONFLICTwhere a constraint name is given instead of a set of columns.We currently don't support this, but we should:
cockroach/pkg/sql/parser/sql.y
Line 4808 in 07d85bd
This would have been a solution for #27981 if we supported it.
cc. @knz for triage. Perhaps @emsal1863 would be interested in working on this?