TypeOrm: PrimaryGeneratedColumn() starts from 1 even when data exist

Question

I'm using Typeorm + typegraphql + Postgre.

I have a Contact table, and defined as:

@Entity("contact")
@ObjectType()
export class Contact extends BaseEntity {
  @Field((type) => Number)
  @PrimaryGeneratedColumn()
  readonly id!: number;

  @Field()
  @Column({ length: 128, unique: true })
  name!: string;
}

If the db is empty, id generated starts from 1, adding new contacts with graphql works well.

But if I import some data with pgAdmin, then add new contacts, postgre complains duplicate key value violates unique constraint "PK_xxx", and id still generated from 1, which caused the error.

Is there any way to make this work?

question from:https://stackoverflow.com/questions/65557859/typeorm-primarygeneratedcolumn-starts-from-1-even-when-data-exist

Answer 1

Waitting for answers