gorm automigrator fails with postgres when a view exists despite no updates to struct in migration

[jawad-unmarshal]

GORM Playground Link

go-gorm/playground#508

Description

Scenario:

1. Migrate table (Make sure the struct has some go type of float64 data.
2. Create a View
3. Re-Run Migrations

Expected Result:

All steps complete successfully

Result Achieved

The migrations in step 3 fail.

ERROR: cannot alter type of a column used by a view or rule (SQLSTATE 0A000)

The alteration shouldn't be necessary given the struct hasn't changed at all.

In one case I found out this was because it was converting a column that was numeric to decimal and failing to do so.

steps to get around:

The tests will pass if you specify a particular postgres type to the data like so:

type User struct {
	gorm.Model
	Name      string
	Age       uint
	Birthday  *time.Time
	Account   Account
	Pets      []*Pet
	Toys      []Toy `gorm:"polymorphic:Owner"`
	CompanyID *int
	Company   Company
	ManagerID *uint
	Manager   *User
	Team      []User     `gorm:"foreignkey:ManagerID"`
	Languages []Language `gorm:"many2many:UserSpeak"`
	Friends   []*User    `gorm:"many2many:user_friends"`
	Active    bool
	TestValue float64 `gorm:"type:numeric"`
}

[emilhakobian]

Any updates on this issue? I experience the same problem. After recent update to the latest version of gorm.

[emilhakobian]

Solved when describing aliases explicitly.
-- pgsql
smallint <-> int2
integer <-> int4
bigint <-> int8
decimal <-> numeric

Source: #5627 (comment)

[a631807682]

#5627