Open kylerummens opened 1 year ago
The above sql would work without the double quotes around the index name.
Can you show an example of that working in plain SQL?
According to postgresql docs, on conflict
only works on column names or constraint names.
Feature request
Is your feature request related to a problem? Please describe.
The
upsert
method has an optionalonConflict
which is described in the docs as:I'm trying to do the following:
and I am getting the following error:
Looking under the hood, it looks like the PostgreSQL is being generated like this:
The above sql would work without the double quotes around the index name.
Describe the solution you'd like
A way to specify a unique index to be used in the ON CONFLICT statement, instead of a column name.
I don't know what the js would look like, but an example could be: