Hello there, I have a field coming from a third-party and its type is long what Ecto datatype should I use to be able to save the field in postgres as long? Since int produces this error ** (DBConnection.EncodeError) Postgrex expected an integer in -2147483648..2147483647, got 8510569521150675000.…

Just provide a value in the range. Ecto/Postgrex should do the right thing then.

I think the value is coming from a 3rd party, @aligredo can’t control that. The value you’re trying to save @aligredo is larger than even a bigint column, i think you’ll need to use a decimal column type PostgreSQL: Documentation: 11: 8.1. Numeric Types

Oh, that way round… I thought the DB schema was provided by a third party and now the OP can’t insert their own values… Edit Basically I see 5 possibilities for you (random order): Clamp the value that it fits your database Modulo the value such that it fits your database drop the value Tell the…