CODEWITHSUNDEEP
postgresqlgodatabase-migrationpsqlgo-gorm
Nathaniel Rand
Nathaniel Rand

Reputation: 571

Auto-migration issues with columns in Golang GORM

Issues with auto migration (i think). I can conclude the column does not exist via psql console. I can insert the column manually via terminal/console/SQL but prefer to resolve this with auto migration.

Thank you for your read and/or action.

TERMINAL OUTPUT:

Upvotes: 0

Views: 2271

Answers (1)

Nathaniel Rand
Nathaniel Rand

Reputation: 571

Credit: Jon Calhoun

Resource: https://www.usegolang.com/

"...the short answer is that automigrate fails to run because when it adds the column and says it can't have null values this contradicts the fact that any existing records will have a null value by default. The simplest fix since you are still in a dev env is to delete all the users from your table either by dripping the entire table or by running some SQL."

Many thanks to Jon Calhoun for this simple and effective solution.

Upvotes: 3

Related Questions