The postgresql throws an exception when the PRIMARY KEY is not type long.

[fx8080]

org.postgresql.util.PSQLException: Bad value for type long : xxxxxx

case at com.speedment.runtime.core.internal.db.AbstractDbmsOperationHandler.handleSqlStatement(AbstractDbmsOperationHandler.java:234)

the source code is:
try (final ResultSet generatedKeys = ps.getGeneratedKeys()) {
while (generatedKeys.next()) {
sqlStatement.addGeneratedKey(generatedKeys.getLong(1));
}
}
}

[minborg]

Can you please post the table creation statements and it will be easier to reproduce the error.

[lawesson]

Reproduced with

CREATE TABLE salesinfo.serialid
(
    id character varying(255) NOT NULL,
    email character varying(255),
    CONSTRAINT primarykey PRIMARY KEY (id)
)

and

    @Test
    public void testInsert() { 
        serialIds.persist(new SerialidImpl().setId("foo").setEmail("mail"));
        Serialid item = serialIds.stream().findAny().orElseThrow(RuntimeException::new);
    }