pg_graphql icon indicating copy to clipboard operation
pg_graphql copied to clipboard

Document that `serial` and `generated` columns are not in `insert` and `update` mutations

Open olirice opened this issue 1 year ago • 1 comments

Document that setting a type as serial or generated removes those fields from the insert and update types so end users can't provide a value and they're always generated by postgres

This is intentional behavior so users can't, for example, select their own value for a table's id, which will later by emitted by sequence which will conflict and create raise an error.

olirice avatar Mar 19 '24 04:03 olirice

ref https://github.com/supabase/pg_graphql/issues/470#issuecomment-2005729498

olirice avatar Mar 19 '24 04:03 olirice