PostgreSQL Sequence not created correctly for serial using Model First
Posted: Fri 17 Feb 2017 23:46
Hi,
I might be doing something wrong, if I am please let me know, but it appears that the serial sequence is created as a bigserial sequence when using model first approach.
In the entity designer I checked the Auto Generated Value and made the dotnet type Int32 and the server type int4 for some tables and for some other tables I used dotnet type Int64 and bigint for the server type.
The problem is all the sequences were created with a max value of 9223372036854775807 instead of 2147483647 for the int4.
I might be doing something wrong, if I am please let me know, but it appears that the serial sequence is created as a bigserial sequence when using model first approach.
In the entity designer I checked the Auto Generated Value and made the dotnet type Int32 and the server type int4 for some tables and for some other tables I used dotnet type Int64 and bigint for the server type.
The problem is all the sequences were created with a max value of 9223372036854775807 instead of 2147483647 for the int4.