Postgraphile: how to create with serial primary key

[jmparsons]

I'm trying to do the most simple create mutation.

mutation ($user:UserInput!) {
  createUser(input: {user:$user}) {
    user{
      id
      name
    }
  }
}

variables:

{"user": {"id": 1, "name": "John" }}

How can I omit the id field?

{"user": {"name": "John" }}

schema:

create table mydb.user (
  id              serial not null primary key,
  name            text not null
);

[benjie]

@jmparsons If you've marked id as primary key and it has a default then you shouldn't need to specify id; if you're still struggling please provide your database schema (or at least the user table) and we'll try to help 👍

[jmparsons]

@benjie Hi I've updated my question with the schema. It's just two fields id and name.

[benjie]

@jmparsons You should be able to just omit the id... is it that you've set the variables to client instead of user?

If you look in GraphiQL you should see something like this:

The id: Int has no exclamation mark so is not required.

[jmparsons]

@benjie I got it to work, but I had to wipe my data. I have a data seed and the increment tries to use a key that's already be applied giving me "duplicate key value violates unique constraint \"user_pkey\"".

I guess is there a way to update the postgres cursor or something along those lines for seeded data?

[benjie]

That's entirely a PostgreSQL concern; you'd have the same issue on the command line with psql

(But since you asked: you're looking for the ALTER SEQUENCE command)

To keep things manageable I'm going to close this issue as I think it's solved; but if not or you require further help please re-open it.

[jmparsons]

@benjie You're the best!