Non primary key integers are generated as "serial"

[m-ghaoui]

I have a model that looks like this:

public int Images_Large { get; set; }

And it has a default value defined in the OnModelCreating of a DbContext

entity.Property(e => e.Images_Large).HasDefaultValueSql("250");

The above code was generated by scaffolding an existing PostgresSQL database. I don't think it matters if you use HasDefaultValueSql("250") or HasDefaultValue(250).

When you try to update a PostgresSQL database, you get this error:

42601: multiple default values specified for column "Images_Large" of table "MyTable"

I generated a script using dotnet ef migrations script -o First.sql and loaded it in pgadmin3. The column was scaffolded as such:

"Images_Large" serial NOT NULL DEFAULT (250),

The "Images_Large" column is not the primary key of the database and therefore should not be mapped as serial. I changed the script to:

"Images_Large" integer NOT NULL DEFAULT (250),

And it's fixed.

This also happens to short and byte too.

[roji]

@Yuioup I'll take a look, but can you please post the full model definition, not just the field?

[roji]

@Yuioup it's OK, I think I understand what's going on (full model not needed).

[m-ghaoui]

Ok cool :-)

[m-ghaoui]

Awesome!