Error: Index contains column that is missing in the entity - @Index isn't using column name from @Column

With an entity like this:

@Entity()
@Index(["country","iso3","region","name","rei_name"], { unique: true })
export class BurdenRegion implements Region {

    @PrimaryColumn()
    @Column({ length: 56 })
    country?: string;

    @PrimaryColumn()
    @Column({ length: 6})
    iso3?: string;

    @PrimaryColumn()
    @Column({ length: 12})
    region?: string;

    @PrimaryColumn()
    @Column({ length: 56})
    name?: string;

    @PrimaryColumn()
    @Column({name:"rei_name",length: 5})
    reiName?: string;
}

I get the following error:

Index contains column that is missing in the entity: rei_name

I want rei_name to be called reiName in the entity, so I added the column name property

@Column({name:"rei_name",length: 5})

But it’s not being used. If I change the @Index to use the entity name like this:

@Index(["country","iso3","region","name","reiName"], { unique: true })

I get another error:

error: column BurdenRegion.reiName does not exist

So I’m not sure how to configure this properly?

Issue Analytics

State:
Created 6 years ago
Comments:6 (4 by maintainers)

Top GitHub Comments

3reactions

pleerockcommented, Sep 22, 2017

Actually BurdenRegion.reiName is correct one since Index decorator expects property names, not database column names. Adding indices expert - mr. @iz-iznogood

1reaction

iz-iznogoodcommented, Sep 24, 2017

Hi all

this is the proper declaration, it works like a charm

@Entity()
@Index(["country", "iso3", "region", "name", "reiName"], { unique: true })
export class BurdenRegion /* implements Region */ {

  @PrimaryColumn({ length: 56 })
  country?: string;

  @PrimaryColumn({ length: 6 })
  iso3?: string;

  @PrimaryColumn({ length: 12 })
  region?: string;

  @PrimaryColumn({ length: 56 })
  name?: string;

  @PrimaryColumn({ name: "rei_name", length: 5 })
  reiName?: string;
}