PG v10 GENERATED BY DEFAULT AS IDENTITY result in Not-NULL violation #2508
Description
To reproduce:
0. Important: make sure to run this mutation as anonymous (ie not as hasura admin etc). Set "anonymous" permisions on insert and select actions for example (as shown in the link below)
- Create following table:
CREATE TABLE color (
color_id INT GENERATED BY DEFAULT AS IDENTITY,
color_name VARCHAR NOT NULL
);
- Run following mutation:
mutation colorInsert{
insert_color(objects: {color_name: "green"}){
returning {
color_id
color_name
}
}
}
You should the see the following result:
{
"errors": [
{
"extensions": {
"path": "$.selectionSet.insert_color.args.objects",
"code": "constraint-violation"
},
"message": "Not-NULL violation. null value in column "color_id" violates not-null constraint"
}
]
}
Further info:
- Hasura running ontop of a v10 PG database
- Hasura v1.0.0-beta.2
- Note: that it works if
x-hasura-admin-secretheader is passed in console headers