Error when Create New Database Record

[MohammedTawfik]

GORM Playground Link

go-gorm/playground#650

Description

i got the following error "failed to parse nextval(' as default value for int, got error: strconv.ParseInt: parsing "nextval('": invalid syntax
0 failed to parse nextval(' as default value for int, got error: strconv.ParseInt: parsing "nextval('": invalid syntax" when try to create new record in the database i used GORM gen to generate the models and use them when create the database record

[xuxing421]

It seems like there is something wrong about type changing，trying to check if struct column type is what you expected

[a631807682]

Is there any real usage scenario?

[MohammedTawfik]

i created postgres database using migration scripts then use GORM to create the structs then when try to insert any record in the database this error is occured

[southwolf]

@a631807682 @MohammedTawfik

I'm wondering if the default tag works

I also hit a similar issue. I'm trying to use it in PostgreSQL on an existing table when migrating a Java app to Go, the default value of ID is not set in the table, but it's controlled in Hibernate instead

@SequenceGenerator(name="my_generator", sequenceName = "my_seq")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "my_generator")

But when I try to create a token

type Token struct {
	TokenId            int64 `gorm:"column:token_id;default:nextval('my_seq');primaryKey"`
}

It does not generate TokenId automatically, but reports ERROR: null value in column "token_id" of relation "token" violates not-null constraint.

[a631807682]

@southwolf Not currently supported

[southwolf]

@southwolf Not currently supported

Thanks for confirming. Now I am using a workaround

db.Raw("SELECT nextval('my_seq')").Scan(&entity.id)
db.Create(&entity)