upsert queries do not work for non admin roles #239
Description
- Create a table
usertable with typesid, nameand primary key:id, - Create a permission for the user allowing any insert and allowing upserts too
This query is valid per GraphiQL:
X-Hasura-Role: user
X-Hasura-Role: 1
mutation {
insert_user(
objects:[{name:"test"}],
on_conflict: {
constraint: user_pkey
action: update
}
) {
affected_rows
}
}
But returns this error from postgres:
{
"errors": [
{
"path": "$",
"error": "constraint \"user_pkey\" for table \"user__insert__public__user\" does not exist",
"code": "postgres-error"
}
]
}