AutoMigrate failed (type "bigserial" does not exist)

[enzofoucaud]

GORM Playground Link

go-gorm/playground#391

Existing database without using GORM :

DROP TABLE IF EXISTS "events";
DROP SEQUENCE IF EXISTS events_id_seq;
CREATE SEQUENCE events_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;
CREATE TABLE "public"."events" (
    "id" integer DEFAULT nextval('events_id_seq') NOT NULL,
    "town" text NOT NULL,
    "latitude" real NOT NULL,
    "longitude" real NOT NULL,
    "kind" text NOT NULL,
    "species" text NOT NULL,
    "description" text NOT NULL,
    "user_publisher" integer NOT NULL,
    "time" timestamp NOT NULL,
    "disabled" integer NOT NULL,
    "report" integer NOT NULL,
    CONSTRAINT "events_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

Model used with GORM :

type Event struct {
	gorm.Model
	Town           string    `gorm:"not null"`
	Latitude       float64   `gorm:"not null"`
	Longitude      float64   `gorm:"not null"`
	Kind           string    `gorm:"not null"`
	Species        string    `gorm:"not null"`
	Description    string    `gorm:"not null"`
	User_Publisher int       `gorm:"not null"`
	Time           time.Time `gorm:"not null"`
	Disabled       int       `gorm:"not null"`
	Report         int       `gorm:"not null"`
}

Function that opens the database and migrates the data :

func (store PostgresRepository) Open(dsn string) (*PostgresRepository, error) {
	// Open database
	db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})
	if err != nil {
		return nil, err
	}
	log.Info().Msg("Connected to db")

	// Create the new SQLite repository
	sql := NewPostgresRepository(db)

	// Migration database
	if err := db.AutoMigrate(&Event{}); err != nil {
		return nil, err
	}

	return sql, nil
}

Error : 2021/10/19 15:14:19 /home/enzo/go/pkg/mod/gorm.io/driver/postgres@v1.1.2/migrator.go:252 ERROR: type "bigserial" does not exist (SQLSTATE 42704)

Description

Before using GORM I was using pgxscan and doing automatic migrations via a script.
Recently I switched to GORM which is more efficient but I get this error during the migration.

Why do I get this error?

Same problem here #4765

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 2 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[ghost]

@enzofoucaud hello, can you provide a demo in https://github.com/go-gorm/playground?

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 2 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[enzofoucaud]

I try it when I have time

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 2 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[enzofoucaud]

@longlihale

go-gorm/playground#391

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 2 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[enzofoucaud]

Hello, any news about this issue ?

[Hanggi]

Any updates or work around? It seems to cause auto migration fail.

[ghost]

I see see....:kissing_closed_eyes:

[enzofoucaud]

I see see....😚

Thanks, because I want to launch my app in prod :)

[mehdipourfar]

I'm also facing this problem after updating gorm

[enzofoucaud]

I'm also facing this problem after updating gorm

Which version ?

I tested v1.22.2 & v1.21.16

[mehdipourfar]

I'm also facing this problem after updating gorm

Which version ?

I tested v1.22.2 & v1.21.16

After this updates in dependencies:

•   gorm.io/driver/postgres v1.1.0  ----> gorm.io/driver/postgres v1.2.1
  

•   gorm.io/gorm v1.21.13 ----> gorm.io/gorm v1.22.2
  

[benjamineskola]

I’ve had this issue too (gorm.io/driver/postgres v1.2.2, gorm.io/gorm v1.22.2, Postgres server v14.1) and found that overriding the type of the primary key works as a workaround:

type Something struct {
    ID                uint `gorm:"type:integer”`
    …
}

edit: that’s not entirely right, as it’ll need AUTO_INCREMENT or something set as well.

[jpmeijers]

Also being affected here after upgrading from jinzhu/gorm to gorm/gorm. Tables in the database were created with the earlier version, now the new version's migration is trying to update them, but fails with this error message:
Unable autoMigrateDB - ERROR: type "bigserial" does not exist (SQLSTATE 42704)