The id column used as the primary key for ais_clean (and other tables) is set to "serial" when the table is created, meaning that the maximum number it can reach is 2,147,483,647 because it follows the limit of the integer data type (https://www.postgresql.org/docs/9.1/static/datatype-numeric.html).
This should be changed to "bigserial," otherwise an "integer out of range" error will be raised when trying to insert rows beyond this limit.
The
idcolumn used as the primary key forais_clean(and other tables) is set to "serial" when the table is created, meaning that the maximum number it can reach is 2,147,483,647 because it follows the limit of the integer data type (https://www.postgresql.org/docs/9.1/static/datatype-numeric.html).This should be changed to "bigserial," otherwise an "integer out of range" error will be raised when trying to insert rows beyond this limit.