Autonumber type issue in Postgre

0
Hi all,   I got issue for AutoNumber type in my entity. When I create object , field that have type AutoNumber is generate wrong number  such as start with 2,4,6,8,10,12,14… . This issue occure on Postgre only in build-in data is correct. db : PG13 and 9.1.1 (I try to reset seq, not working. All ENV with Postgre got issue )   I try to use SQL to select nextval from db ,it’s ok . it show correct seq and try to insert data from SQL I got AutoNumber field is null . (I guess this problem from mendix , is not Postgre , right ?)   This is my seq setting    
asked
3 answers
0

Could be that you are creating 2 records unintentionally via a microflow, that would explain the increment of 2. The autonumber is created on create of the record, so if I have a microflow with a create action followed by a create action and I open the second record in a page I would expect the behavior you’re seeing.

answered
0

 

Erwin 't Hoen

 

answered
0

Hi Somboon,

 

did you find an answer to this issue?

I may have the same problem, just with a different offset (in my case usually 33 or multitudes of this).

 

Best regards,

Bernd

answered